SQL Indexing

SQL Query should use index seeks and not index scans.

* https://www.red-gate.com/simple-talk/sql/performance/identifying-and-solving-index-scan-problems/

• You can select the 'Display Estimated Execution Plan' (4 to the right of the '! Execute' button).
• You can select 'Include Actual Execution Plan' (7 to the left of the '! Execute' button), so see exactly how the SQL was run, after you execute it.

The below examples are taken from the “Actual Execution Plan”