Db2portal.blogsspot

Comment Wall

You need to be a member of WorldofDb2 to add comments!

Join WorldofDb2

Comments are closed.

Comments

  • Dear John

     

    Could you please explain how to duplicate romove work in DB2 11 without DISTINCT
    and group by, In DB2 11 performance overview document , it is mentioned like we
    have to see IXSCAN_SKIP_DUPS, IXSCAN_SKIP_SCREN and EARLY_OUT columns in
    DSN_DETCOST_TABLE for further information.

     

    Could you please explain me to eliminate the sorting for both DISTINCT and GROUP BY by using DSN_DETCOST_TABLE.
    .

This reply was deleted.

Earned points: 4600
Db2 Fan
Received:
Oct 27, 2021
0
Db2 Leader
Received:
Dec 3, 2021
0

Special

Activity Feed

Jim Reed and John Campbell are now friends
Nov 8, 2021
Paul Jansen and John Campbell are now friends
Oct 27, 2021
John Campbell updated their profile photo
Oct 27, 2021
John Campbell updated their profile photo
Oct 27, 2021