Re: Improvement of the select sentence

From: Davide Bianchi <davidebianchi_at_davidebianchi.net>
Date: Thu, 27 Sep 2001 10:47:19 +0200
Message-ID: <9oup5p$f5cv0$1@ID-18487.news.dfncis.de>

"Jose Ignacio" <jcavia_at_sgt.es> wrote in message news:3bb2dc6f$1_at_news.airtel.net...
> Where Table1.fieldId = Table2.fieldId AND
> Table2.fieldId2 = Table3.fieldId2 (+) AND
> Table1.Otherfield = Value
> ORDERBY field.
>
> My question is if I have to sort the condicions in Where
> clause, or I have to to put index in some field in order
> to gain in execution speed.

If I interpreted the Oracle documentation correctly, if you have an Outer-Join, he is going to perform a table-scan, no matter what you do. Check the documentation.

Davide Received on Thu Sep 27 2001 - 03:47:19 CDT