World of Db2
What best describes your job role?
IBM Employee / Business Partner
Praveen Kumar P S
Koteswar Rao Mandadi
You need to be a member of WorldofDb2 to add comments!
Comments are closed.
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..
Please, subscribe to get an access.
Please check your browser settings or contact your system administrator.