Location
Winchester, Hampshire
About
What best describes your job role?
IBM Employee / Business Partner
Friends (16)
Db2portal.blogsspot
Comment Wall
You need to be a member of WorldofDb2 to add comments!
Comments are closed.
Earned points: 4600
Db2 Fan
Received:
Oct 27, 2021
Oct 27, 2021
0
Db2 Leader
Received:
Dec 3, 2021
Dec 3, 2021
0
Special
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.
.