We finished part 3 with two similar-looking queries that produce very different behavior: one does a seek, and the other does a scan. Now you'll learn why, plus add yet another index to make this query go faster, and then discuss the drawbacks of too many indexes.
Watch video How to Think Like the SQL Server Engine Part 4 online without registration, duration hours minute second in high quality. This video was added by user Brent Ozar Unlimited 09 May 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,839 once and liked it 130 people.