Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!apple!well!anderson
From: anderson@well.sf.ca.us (David E. Anderson)
Newsgroups: comp.databases
Subject: Re: oracle's optimizer
Summary: syntax means more than ordering
Keywords: Oracle optimizer
Message-ID: <23052@well.sf.ca.us>
Date: 8 Feb 91 08:34:45 GMT
References: <9292@cognos.UUCP> <1991Feb6.144339.10316@lgc.com> <1991Feb7.142156.13433@ctl.co.nz>
Organization: Whole Earth 'Lectronic Link, Sausalito, CA
Lines: 10
Followup-To:compdatabases

<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