# REOPTIMIZE

Reoptimize the most recently profiled query based on previous executions of it.

## Syntax

```
REOPTIMIZE [[EXPLAIN] | [COMMIT]] [<reoptimize_level>]

```

## Remarks

* The `REOPTIMIZE` command is used with the `PROFILE` command to look for improved query plans.
* `REOPTIMIZE` works on the most recently profiled query in the current connection.
* The keyword `EXPLAIN` shows the explain output for the reoptimized plan.
* Subsequent `REOPTIMIZE` statements will generate differing plans (`<reoptimize_level>`). Refer to specific subsequent plans with the corresponding number of the order in which the `REOPTIMIZE` was executed. For example, if you run `REOPTIMIZE` three times consecutively on the same query profile, you can rerun the second of the optimizations by referring to its place in the order of execution, like so:
  ```sql
  REOPTIMIZE 2;
  ```
* To save a reoptimize plan to apply to a query, use the `COMMIT` keyword:
  ```sql
  REOPTIMIZE COMMIT 2;
  ```
  After running the above statement, the query will use the plan generated the second time `REOPTIMIZE` was executed.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.
* Refer to [REOPTIMIZE MARK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/reoptimize-mark.md) for automatic feedback reoptimization.

## Example

```sql
PROFILE <query text>;
REOPTIMIZE EXPLAIN; -- prints the explain of the reoptimized plan
REOPTIMIZE; -- runs the reoptimized plan as a profile;
SHOW PROFILE; -- shows the reoptimized profile
REOPTIMIZE; -- Runs reoptimize with the previous two executions stats
REOPTIMIZE; -- Runs reoptimize with the previous three executions stats
REOPTIMIZE 2; -- Runs the reoptimize plan from the second reoptimize
REOPTIMIZE COMMIT 2; -- Runs and saves the second reoptimize plan to <query text>
<query text>; -- Uses the committed reoptimize plan
```

***

Modified at: October 1, 2025

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

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