Distinct summary

Provides information about any DISTINCT processing. SELECT DISTINCT in an SQL statement may be a time consuming operation because a final sort may be necessary of the result set to eliminate duplicate rows. DISTINCT in long running SQL statements should only be used if it is absolutely necessary to eliminate the duplicate resulting rows.