Db2portal.blogsspot

Comment Wall

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

Join WorldofDb2

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

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, 2021
Paul Jansen and John Campbell are now friends
Oct 27, 2021
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, 2021
John Campbell updated their profile photo
Oct 27, 2021
John Campbell updated their profile photo
Oct 27, 2021