Re: QUERY TUNING
Date: Thu, 18 Dec 2008 10:57:30 -0800 (PST)
Message-ID: <6ed48824-70da-4c15-a6f2-450931c6fc63@q26g2000prq.googlegroups.com>
On Dec 18, 1:31 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Dec 18, 4:22 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> > This appears to be some version of Oracle 10g, based on the "SORT
> > GROUP BY NOSORT" in the explain plan, and the DBMS XPLAN type format
> > of the explain plan which includes the predicate information.
>
> Keep up the good works, the rare brain-fart or typo keeps us on our
> tippy-toes.
>
> jg
I was thinking about the HASH GROUP BY optimization in 10g when I wrote the above. I realized my mistake right after I posted - the OP had replied that he was running 9i, which caused me to wonder how could that be the case?
Thanks for the links.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Thu Dec 18 2008 - 12:57:30 CST