Adaptive query execution (AQE) attempts to reoptimize a query if a specific trigger fires during query execution indicating that it is non-optimal, so a more efficient plan should be searched for.

AQE is disabled by default. To activate it, set the aqe_enable configuration parameter to on. The compute_plan_id configuration parameter should be set to auto (default) or on to enable in-core computation of plan identifiers.

AQE currently has the following limitations: