Re: Plan stability with rule based optimzier

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 11 Feb 2005 15:06:49 +0000
Message-ID: <7765c897050211070654a7ae4f@mail.gmail.com>

other groups I can't post to snipped

On Fri, 11 Feb 2005 15:57:39 +0100, Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:
> sorry -- I was trying to say two things at the same time.
> The CHOOSE hint only kicks in CBO if statistics are available,
> because otherwise it would default back to RULE, making the hint useless.
> Therefore I assumed the presence of object statistics.
> So if the intent is to deviate from RULE behavior for a specific SQL
> statement,
> using ALL_ROWS or FIRST_ROWS(n) is the preferred method.

Q1. If RULE is *really* set at the database level (i.e in the parameter file you have OPTIMIZER_MODE=RULE) is it safe to collect stats anyway.

Q2. If you can modify the SQL by hinting it, can you modify the SQL?

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 11 2005 - 10:09:33 CST