REOPTIMIZE MARK
Manually mark a plan for Feedback Reoptimization.
Run the following series of commands to manually mark a plan for FR:
-
Run SHOW PLANCACHE to list plans and obtain the
ID
of the plan to be reoptimized.SHOW PLANCACHE; -
Run REOPTIMIZE MARK to mark the plan for FR.
REOPTIMIZE MARK <plan_id>;
After a plan has been marked, the next execution of the query will trigger FR.
Last modified: October 1, 2025