Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cost Based Optimizer
With the large tables you can get real pain in but with CBO (on Oracle
7.3.3). I can prove that.
I would suggest use RULE, and in SELECT statement FROM clause arrange your
tables so,that smaller appear first, but the big ones as the last.
>Jerry wrote:
>
>> I have a query against a view that is very slow in RULE, but fast in
cost.
>> But for other reasons I want to run the database in RULE. When I
re-create
>> the view with a /*+ CHOOSE */ hint and run it under RULE mode,
EXPLAIN_PLAN
>> will execute it differently in the database under CHOOSE mode, without
the
>> hint on the view.
>>
>> Is this behavior normal? BTW, all tables have statistics estimated in
both
>> scenarios.
>>
>> Thanks.
>
Received on Fri Dec 11 1998 - 03:52:01 CST