Tuning : Where clause

From: <a_andy_at_my-dejanews.com>
Date: Thu, 24 Sep 1998 16:58:51 GMT
Message-ID: <6udtoa$ju9$1_at_nnrp1.dejanews.com>

I have a table account(ac_code,ac_date,acd_exp_date,ac_flag.....) and the primary key of the table ac_code. Now when I write a query "Select .... from account where ac_code = '123' and ac_date between .. and ..
and ac_exp_date < ..
and ac_flag = 'A'"

Which would be the best position for ac_code field condition in the where clause. If it the first condition in where clause , will oracle stop looking for further conditions for the recrods which don't have ac_code = '123' ??

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 - 18:58:51 CEST