ANALYZE TABLE

SafeRefresh optimizer stats

ANALYZE TABLE <table>;

Updates planner statistics — the fix when indexes exist but go unused after bulk loads.

Examples

ANALYZE TABLE orders;Refresh stats

Syntax

ANALYZE TABLE t;(MySQL) / ANALYZE t;(PostgreSQL)

Before you run it

Stats refresh only.

Related commands

EXPLAINQuery plan
OPTIMIZE TABLERebuild/defragment tables

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store