Re: DBA_OBJECTS using Distinct Vs Group By

On 6/22/06, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:
>
> Any ideas why "GROUP BY" query is faster that
> "DISTINCT" in this query?
>
> SELECT OWNER FROM DBA_OBJECTS GROUP BY OWNER;
>
>
>

Without doing any real analysis on it, I'm guessing that the group by is getting benefit from the new "HASH GROUP BY" in 10g.

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l