Comment Wall

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

Join WorldofDb2


  • 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
Oct 27, 2021
Db2 Leader
Dec 3, 2021


Register for the Webcast to get a head start! 

Direct Link http://ibm.biz/DB2zContinuousDelivery

On  the 27th September Chris Crone and I will be running a webcast with live Q&A afterwards for our worldwide customers where we will introduce and describe the DB2 for z/OS product strategy going forward for continuous delivery of new functions in…

Read more…

Activity Feed

Jim Reed and John Campbell are now friends
Nov 8
Paul Jansen and John Campbell are now friends
Oct 27
John Campbell posted a blog post
Earlier this year, I hosted a client panel with several of our Db2 12 clients about the sucesses and migration of Db2 12, this event is now available on replay. .
Oct 27
John Campbell updated their profile photo
Oct 27
John Campbell updated their profile photo
Oct 27