Where-clause terms in order? 1

[graabein]

Hi,

I have a rather large table with indexing on the department ID. Some places I just use the employee ID to lookup records. Should I change these to Where dept_id=4 and emp_id=15329 instead of just Where emp_id?

Will it run more effective?


graabein

 

[r937]

will it run more efficiently? it might

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[graabein]

Because emp_id is the primary key. I suppose any table is indexed on the primary key but if dept_id reduces the bulk of records for the key-lookup... is there a Yes/No answer for this?

 

[r937]

if emp_id is the primary key, then no, adding additional conditions might actually slow it down

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)