Why DISTINCT is costly?

Whenever I use a DISTINCT in my query, I see the "SORT UNIQUE" getting added to the execution plan.

"SORT UNIQUE" is increasing the cost of the query by a greater factor.

Any help in reducing the cost in using DISTINCT would be of much help.

Thanks in Advance. Received on Mon Sep 12 2005 - 01:45:05 CDT