Re: Oracle Optimizer Questions.

In <BvGIps.5yC_at_inews.Intel.COM>, kortikar_at_mipos2.intel.com (Aniruddha Kortikar) writes:

> I need some help in understanding oracle optimizer -
> consider following tables -
> ...
> these are the explain plan outputs I got from oracle 6.0.33.+

the oracle version 6 optimizer doesn't use cost analysis. oracle does "semantic" query optimization, which is to say, it executes joins in the order in which you write them, and will use an index if one happens to be around. it doesn't reorder the query in any way.

i believe that version 7 provides cost-based optimization.

                                        mike olson Received on Fri Oct 02 1992 - 18:04:06 CET