SQL SERVER – INDEX SEEK AND INDEX SCAN

During the examination of SQL Server execution plan you may come across Index scan and seek in the execution plan. Here I am giving small description about the Index seek and Index scan.

  • INDEX SCAN:

   The index scan will scan all the data in the data page. Index scan is useful if the table has small amount of datasets. The index scan can be considered as a table scan.

  • INDEX SEEKS:

            The index seek is good at performance optimization point of view. Index seek will only seek for the satisfying query conditions. I will write more on Performance tuning later.