Key selection icon

Index Scan

The Index Scan icon indicates that the entire index will be scanned causing all of the entries in the index to be paged into main memory to be processed. Any selection criteria, whose predicates match the key columns of the index, can then be applied against the index entries. Only those key entries that match the specified key selection will be used to select rows from the corresponding table data. If the icon label is Index Scan Distinct or Index Scan Distinct, Preload, then, for any duplicate key entries that would be selected, only one of the entries will be used to select rows from the corresponding table data.

Also referred to as: Index Scan - Key Selection; Index Scan, Preload; Index Scan Distinct; Index Scan Distinct, Preload

See Tips for index scan for more details.