Index Scan

SQL Server query plan explanation

Optimizing