Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Improvement of the select sentence
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
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