Re: Cost Vs. Rules Based Optimizers

>
>Has anyone done any extensive testing between the two optimizers where you
>have switched from running highly optimized and very large queries against a
>optimizer and most of them go against two entire years of sales history.
> (Stuff deleted...)
>We know there are minor differences in syntax, such as the driving table

We haven't run tests yet, but according to the Oracle Tuning App. under v 7 class (which I took last week -- and recommend) syntax is supposed to have no effect on the execution plan generated by the cost-based optimizer (that is, order of FROM tables and WHERE clauses). Supposedly it uses only infomation generated by ANALYZE.

Of course, the claims may be wrong....:-)

-- 
   Vince Ventrone
   The MITRE Corporation       "...In my opinion, there's nothing
   Bedford, MA 01730           in this world beats a '52 Vincent
   vav_at_mitre.org               and a redheaded girl."  -- Richard Thompson