Re: Ordering operands of a WHERE clause

On Tue, 30 Dec 2003 17:58:21 +0000 (UTC), weberm_at_polaris.net (Ubiquitous) wrote:

>I have this SELECT statement in a cursor that's giving me performance
>problems and am wondering if reordering the conditions in the WHERE
>clause would make a difference in performance. Does it help if one
>lists the most restrictive conditions first?
>

Not very likely. You may want to use ( ) however, to make sure the parser is using the correct mathematical priorities. This used to apply especially if you used x>= ... and x <= ... and instead of x between ... and ... and

--
Sybrand Bakker, Senior Oracle DBA