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. .
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.
.