Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Improvement of the select sentence

Improvement of the select sentence

From: Jose Ignacio <jcavia_at_sgt.es>
Date: Thu, 27 Sep 2001 09:52:10 +0200
Message-ID: <3bb2dc6f$1@news.airtel.net>


Hi
I have a ORACLE database in a linux server. I have a client aplication to access to it. I have a select sentence that I want to optimize. The sentence is like that: (schematically)

Select Table1.field, Table2.field, Table3 field, .... From Table1, Table2, Table3
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.

Thanks in advance. Received on Thu Sep 27 2001 - 02:52:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US