On 6/22/06, Deepak Sharma <sharmakdeep_oracle@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@yahoo.comweb:
http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
