Top 16 performance query optimization techniques in SQL Database?
Top 16 performance query optimization techniques in SQL Database
You could also use an appropriate filtered index for your non clustered index because it could avoid performing
a key lookup..