How to Analyze a Table in Redshift

Last updated July 25, 2026 · By the SaturnSQL team

ANALYZE updates the planner statistics Redshift uses to choose join and distribution strategies. Run it after large loads, and check the stats_off column in SVV_TABLE_INFO to see which tables have stale stats.

ANALYZE orders;
ANALYZE orders (customer_id, created_at); -- specific columns only

SELECT "schema", "table", stats_off
FROM svv_table_info
WHERE stats_off > 10
ORDER BY stats_off DESC;