Imported Statistics
Statistics | Is imported | Description |
---|---|---|
Row count | ✅ | Indicates the number of rows in table |
Last user query | ❌ | - |
Number of user queries | ❌ | - |
Last user update | ✅ | Time of last user update |
Number of user updates | ✅ | Number indicated sum of inserts, updates and delets done on table |
Last load time | ❌ | - |
Requirements
Dataedo requires access to the following tables and views:
- all_tables
- all_tab_partitions
- all_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