Improved duplicate removal from SQL results
In Db2 11, Db2 improves the processing of removing duplicates from SQL results.
Db2 might optimize the processing of certain types of SQL statements that remove duplicates during processing. Some improvements require an index. Examples of SQL statements that are affected include:
- SELECT DISTINCT
- Single SET FUNCTION DISTINCT
- GROUP BY without set functions
- GROUP BY with single SET FUNCTION DISTINCT
- Single MAX or MIN set function
- GROUP BY with single MAX or MIN set function
- SELECT with a subquery