Optimize a table

sql

OPTIMIZE TABLE orders;

Explanation

Best used intentionally; its effect and cost depend on the storage engine and workload.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing explain and analysis

View the optimizer's execution plan.

Open In sheetsqlsame section

Execute the query and include actual timing information.

Open In sheetsqlsame section

Update optimizer statistics for a table.

Open In sheetsqlsame section

Obtain the plan for a statement running in another session.

Open In sheetsqlsame section

Add an index for a frequently filtered column.

Index multiple columns in left-to-right order.