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 and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store