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 so see exactly how the SQL was run, after you execute it.

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