# REOPTIMIZE MARK

Manually mark a plan for [Feedback Reoptimization](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/feedback-reoptimization.md).

Run the following series of commands to manually mark a plan for FR:

* Run [SHOW PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-plancache.md) to list plans and obtain the `ID` of the plan to be reoptimized.
  ```sql
  SHOW PLANCACHE;

  ```
* Run [REOPTIMIZE MARK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/reoptimize-mark.md) to mark the plan for FR.
  ```sql
  REOPTIMIZE MARK <plan_id>;
  ```

After a plan has been marked, the next execution of the query will trigger FR.

***

Modified at: October 1, 2025

Source: [/db/v9.1/reference/sql-reference/data-manipulation-language-dml/reoptimize-mark/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/reoptimize-mark/)

(An index of the documentation is available at /llms.txt)