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_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