Position of columns in where clause
From: <a_andy_at_my-dejanews.com>
Date: Thu, 24 Sep 1998 17:01:30 GMT
Message-ID: <6udtt9$k2h$1_at_nnrp1.dejanews.com>
[Quoted] 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.
Date: Thu, 24 Sep 1998 17:01:30 GMT
Message-ID: <6udtt9$k2h$1_at_nnrp1.dejanews.com>
[Quoted] 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
[Quoted] -----== 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:01:30 CEST