Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |