SQL Server Indexing Strategy Puzzle

Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One Performance Tuning Bundle. 5 courses at a highly discounted price. bit.ly/sqlmaestrosallinone
The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.

[@marancibia1971]

in the predicate TerritoryID is the first column because its equality condition and SalesOrderID is the second for its inequality condition. It's the best combination for selectivity.

[@minnrick7986]

You present a problem (an important, common one), a series of possible answers and.. subscribe to premium content to get the answer. This was nothing more than an ad. Thumbs down.

[@SQLMaestros]

We record dozens of free videos & tutorials each week for the community - full length stuff. So sometimes a teaser/ad should not be a problem. Thumbs up to your feedback & thumbs up to our work.