Re: Strange choice of index

On Fri, 21 Dec 2001 10:56:17 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>This is the rule based optimizer working according
>to the list of priorities defined in the manual. (Though
>I'm not sure that list exists any more in the v8
>manuals).

It is.

Oracle8i Designing and Tuning for Performance Release 2 (8.1.6)
Part Number A76992-01
Chapter 4, "The Optimizer"
Section: Optimizing Joins
Sub-Section: Choosing Execution Plans for Joins with the RBO

<<
With the rule-based approach, the optimizer performs the following steps to choose an execution plan for a statement that joins R tables: <<

Brian Received on Fri Dec 21 2001 - 08:17:08 CST