Optimizing Select...In Clauses in SQL Server Views

Provided by Molly Pell, Senior Systems Analyst

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.

Additional Resources



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.

Darren D.

View all FMS products for Microsoft Access All Our Microsoft Access Products



Free Product Catalog from FMS