How to Think Like the SQL Server Engine, Part 2: Nonclustered Indexes
That last module was horrible – it’s so much work when you only have a clustered index! In this module, you’ll get two nonclustered indexes, learn which one is more useful, and see why seek doesn’t mean awesome.