Position of columns in AND/OR of where clause

From: <a_andy_at_my-dejanews.com>
Date: Thu, 24 Sep 1998 17:01:02 GMT
Message-ID: <6udtsd$k28$1@nnrp1.dejanews.com>

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 Received on Thu Sep 24 1998 - 12:01:02 CDT