Re: Performance and table order

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 1997/07/04
Message-ID: <01bc88aa$857d98f0$294b989e@WORKSTATION>#1/1

Robert Risholm <risholmr_at_j51.com> wrote

> Oracle 7.3 supports a COST based optimizer. The "order" of your
statements
> will have no bearing on the execution path Oracle takes, it will
make the
> decision based upon statistics.

Not strictly true.

All other things being equal (which is somewhat less likley with cost based optimisation than rule based) the tables will be processed from left to right (top to bottom).

Jonathan Lewis Received on Fri Jul 04 1997 - 00:00:00 CDT