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.

You cannot use DB2® Symmetric Multiprocessing feature data access methods to access a partitioned table, but you can use these methods when processing temporary tables and for creating temporary indexes.

If the partitioned table is used in a query containing a subquery, the optimizer does not attempt to implement the query as a join composite query. This keeps the partitioned table from being materialized because of the join.