[comp.databases] oracle's optimizer

anderson@well.sf.ca.us (David E. Anderson) (02/08/91)

<stuff deleted>
>May I summarize -  If you get the query statement right, Oracle can optimize
>it, if you get it wrong (by that I mean in the syntactically correct, "wrong"
>order) that Oracle cannot optimise :-(
>From :   Colin McIntosh,  Project Manager
>Internet:    MCINTOSHC@NZFC.CO.NZ

wrong.  order of tables in the FROM clause is the tie breaker when the other
syntactic rules and existence of indexes don't force a choice.
-d