Why Creating an Index Can Slow Down A Query (1 hour 30 minutes)

Or log in to access your purchased courses

In this course, you'll work through a query where SQL Server chooses an imperfect non-clustered index and your query becomes slower than it would be if it just scanned the whole table. Can you speed up the query without modifying any indexes, and only tuning the TSQL?