MSSQL Optimisation

August 18, 2022

Scan count:

• the number of index or table scans performed by the query

Logical read count:

• the number of pages read from the sql server data cache
• the logical reads of N mean that SQL Server reads (N * 8 KB) pages to get the data from memory.