Index column order #SQL #SQLtips #sqlperformance

The order of columns in a composite index affects when the optimizer can use it in SQL queries

See how the plans changed based on which columns are in the where & select clauses.

--

Need help with SQL?

===========================
The Magic of SQL with Chris Saxon