When using SELECT...IN clauses in SQL Server views, order the list of values from most to least frequent in the data set. When you place the most frequently-used values at the beginning of the IN clause, matching is made sooner, and performance is greatly increased.
This tip and more found by Total SQL Analyzer PRO.
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.