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.