Queries using Classic Query Engine

 

When queries are implemented using Classic Query Engine (CQE), be aware of how the query is optimized including materialization and index usage.

• Materialization
  When running Classic Query Engine (CQE), a partitioned table is materialized under some conditions.

• CQE query optimization considerations
  The Classic Query Engine (CQE) optimizer optimizes the query using the first partition member in the partitioned table. This access method is used to access rows from all of the partitions.

• Classic Query Engine: Index usage
  The Classic Query Engine (CQE) uses nonpartitioned indexes to implement queries.

 

Parent topic:

Query performance and optimization