A qualifier that retrieves results with duplicate rows removed.
A qualifier that removes duplicate rows from a SELECT's results, which can sometimes affect performance. Internally, it requires sorting or hashing the result set to detect duplicates, so simply adding DISTINCT to a query over a large table can make it noticeably slower.
© 2026 ITBGM