Background documentationINDEX SCAN Locate this document in the navigation structure

 

INDEX SCAN is a search strategy of the SQL optimizer.

When Can the System Use This Strategy?

The system can choose this strategy, for example, if it can use the index to sort the result as specified in the query (without incurring additional costs).

How Does the System Access the Data?

The database system sequentially searches through the entire specified index to access the data.