Re: Ordering operands of a WHERE clause

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?

Only if you are working on an ancient version of Oracle. And even that might be more mythology than fact.

Is there some reason you didn't post your version and edition? The query?

Most likely you are looking in the wrong place for the problem. Try providing more than cryptic information and you may get more than cryptic answers.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)