Table of Contents
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:
Cursors are not supported.
SELECT statements are only supported
except SELECT FOR UPDATE and
SELECT FOR SHARE.
Statements with volatile functions are not supported.