SQL Query Engine: Index usage

 

The SQL Query Engine (SQE) uses both partitioned and nonpartitioned indexes to implement queries.

If a nonpartitioned index is used, the optimizer can choose to implement the nonpartitioned index for each partition. This implies that, for example, even if the nonpartitioned index is unique, each partition is probed for the row.

 

Parent topic:

Queries using SQL Query Engine