Classic Query Engine: Index usage

 

The Classic Query Engine (CQE) uses nonpartitioned indexes to implement queries.

If a partitioned index exists, the optimizer does not use the index to make optimization decisions concerning the access method to use while processing the partition table.

The optimizer creates temporary indexes over partitioned tables allowing update of live data with ordering.

Because encoded vector indexes (EVIs) are only created over a single partition, CQE cannot use EVIs to implement partitioned table queries.

 

Parent topic:

Queries using Classic Query Engine