Oracle - Table Statistics
Imported Statistics
| Statistics | Is imported | Description |
|---|---|---|
| Row count | ✅ | Indicates the number of rows in the table |
| Last user query | ❌ | - |
| Number of user queries | ❌ | - |
| Last user update | ✅ | Time of the last user update |
| Number of user updates | ✅ | Number indicating the sum of inserts, updates, and deletes done on the table |
| Last load time | ❌ | - |
Requirements
Dataedo requires access to the following tables and views:
all_tablesall_tab_partitionsall_tab_modifications
Limitations
- Statistics in Oracle are not gathered continuously but are instead collected at scheduled intervals. As a result, after importing data, the statistics may not immediately reflect the current state of the database, potentially leading to discrepancies.
Learn more
Read more about table statistics import in main article
