Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: *** HELP ABOUT SINTAX *** --> order of predicates in where clause
"Saimon" <saimon181072_at_supereva.it> wrote in message
news:ciesmn$5ig$1_at_newsreader.mailgate.org...
| Ciao a tutti,
| so che ci sono delle differenze sostanziali per quanto riguarda l'ordine
| delle clausole di WHERE tra SQLServer e ORACLE.
|
| Mi sapete dire dove posso trovare un aiuto riguardo all'ordine dei campi
| all'interno della clausola WHERE ?
|
| Grazie
|
| Saimon
|
|
The order of predicates in the where clause is not as big an issue as it used to be as far as tuning -- of course, if you are using OR's then parenthesis placement is critical.
You should download the Tuning manual and SQL manual at http://tahiti.oracle.com
Any tuning gurus got anything to add about the order of where clause predicates and any effect on the optimizer?
++ mcs
(By the way, it's 'syntax' -- 'sintax' is a tax imposed by the government on cigarettes, alcohol, and other items that some consider to be sinful) Received on Fri Sep 17 2004 - 09:47:12 CDT