📊 Statistics Advisor Read-only

Tables and indexes with stale or missing optimizer statistics — sorted by row count. Each row includes a ready-to-run DBMS_STATS command. Click the command to copy.

Connection:

Checking stale and missing statistics…

Querying DBA_TAB_STATISTICS + DBA_IND_STATISTICS

📊

Select a connection and click "Fetch"

Surfaces tables with STALE_STATS=YES or LAST_ANALYZED IS NULL, sorted by num_rows.

Stale / Missing Table Statistics

Stale / Missing Index Statistics

Statistics Advisor Findings (Oracle 12.2+)