Refresh table statistics

sql

ANALYZE TABLE orders;

Explanation

Refreshing statistics can help the optimizer make better plan choices after large data changes.

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

Reorganize table storage and update index statistics for supported engines.

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.