Order of fields in WHERE 1

[vladk]

Hi,

If I use a composite index, say Field1, Field2, Field3, the order in which these fields are listed in WHERE clause will be important? And if yes, then how should I list them: from top to bottom or from bottom to top?

This is ACCESS database.

Thank you!

vladk

 

[Golom]

No. It doesn't matter what order you use.

Do note however that when you mix "AND" and "OR" operators in a WHERE clause, "AND" us evaluated first and then "OR". Use parentheses to ensure that the order of evaluation is what you intend.

 

[vladk]

Golom,

Thank you!

vladk