Re: Position of columns in where clause

I'm going to be a pain here, the best way to find out is experiment with it, you would not believe how much I've learned about oracle but just doing what you're asking and letting people know my results. In answer to your question it all depends on version of oracle, rule based vs cost based. the list just goes on and on. What you might find works for you in your environment might(or might not) work in the next person's environment. And especially when it comes to tuning, experimentation is the best way to learn. I could tell you what I've come up with but the chance you and I have the same environment(and data for that matter) is slim to none.

joe
http://www.oracle-dba.com

In article <6udtt9$k2h$1_at_nnrp1.dejanews.com>,   a_andy_at_my-dejanews.com wrote:
> I read in O'Reilly book that for non indexed where clause , the least
> expensive AND clause should be last in the AND list and exactly opposite in
> case of OR. But when I checked I found that in case of OR also it works
> faster if I put least expensive OR last ? Please advise.
>
> Would a where clause that has one of the conditions using indexed column and
> all other using unindexed columns be called a non indexed where clause
>
> Thanks
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 24 1998 - 19:58:53 CEST