Re: Top SQL question

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 19 May 2005 01:03:33 -0700
Message-ID: <1116489813.085609.123550@g49g2000cwa.googlegroups.com>

DA Morgan wrote:
>
> Which is precisely why Oracle created the DBMS_XPLAN built-in
package.
> Don't use that package and your chances of getting the correct result
> decrease dramatically.

Bingo. Been using it almost exclusively for a while. Why bother with third party solutions or incorrect historical scripts?

> Also note for the record that building the plan table with
UTLXPLAN.SQL
> is no longer best practice. Instead run CATPLAN.SQL. Stand still very
> long and Oracle will pass you by.

Interesting. Must be 10g? Not in 9ir2. Received on Thu May 19 2005 - 03:03:33 CDT