Index Seek

SQL Server query plan explanation

Optimizing