where conditions

[alekm]

Hi,
I'd like to know which condition in where part of sql will be considered
first. I'd like to optimize sqls.
For example: select * from table t where condition1 and condition2 and
condition3

thank you in advance

alekmil

 

[Stefan Hoffmann]

hi Alek,

I'd like to know which condition in where part of sql will be considered
first. I'd like to optimize sqls.
For example: select * from table t where condition1 and condition2 and
condition3

Order isn't important. For optimizing you need appropriate indices
covering your conditions.

http://msdn.microsoft.com/en-us/library/dd942824.aspx
http://support.microsoft.com/kb/240434
http://support.microsoft.com/kb/162701

mfG
--> stefan <--

 

[Jerry Whittle]

If you want to see how a particular query runs, you need to use the JET
SHOWPLAN.

Check out what Tom Wickerath says about Use JETSHOWPLAN about half way down
this page:

http://www.accessmvp.com/TWickerath/articles/multiuser.htm