ms access sql order of query criteria processing
Posted on 2016-09-26
Assuming the ACE engine is sub-setting as it goes, are the query criteria (in the query designer) processed left-to-right, right-to-left or n/a?
The reason I ask is if there are two criteria in the where-clause, a date and a indexed integer, will the query run quicker with the date on the left or right? (or n/a).
And, can one assume the designer order will be the same as the SQL view order?