Re: Why DISTINCT is costly?

<juhunu_at_gmail.com> wrote in message
news:1126507505.386016.211310_at_f14g2000cwb.googlegroups.com...
> 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.
>

And how else would one be able to
eliminate duplicates without sort
unique?

dk Received on Mon Sep 12 2005 - 02:18:24 CDT