Re: 'RULE' based optimizer on certain tablespace?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 5 Sep 2001 06:54:33 +1000
Message-ID: <3b953e84@news.iprimus.com.au>

Your understanding is correct. But if a table has no statistics, then whatever you've opted for, at whatever level, simply cannot work, and the optimizer must fall back on rule-based optimization.

So I guess your vendor means 'locate every table in that tablespace and delete its statistics'.

Sounds like an, er... interesting product you have there!

Regards
HJR "Helen" <hhjin_at_yahoo.com> wrote in message news:ebcac1e2.0109041148.1dfc2269_at_posting.google.com...
> I have a 8.1.6 Oracle DB with optimizer set to be 'choose'.
>
> Our application vendor suggested to set the optimzier
> to be 'rule' based for a certain tablespace.
>
> Any ideas how?
>
> My understanding is that you can change the optimizer on
> instance level, session or statement level (use /*).
>
> Thanks
>
> Helen
Received on Tue Sep 04 2001 - 15:54:33 CDT