Performance Issue: Gathering Statistics- dbms_stats

What are the advantages of Gathering Statistics?

Showing Answers 1 - 1 of 1 Answers

ushodaya

  • May 20th, 2018
 

We should generate statistics for all tables and clusters and all types of indexes accessed by your SQL statements before using the cost-based approach. If the size and data distribution of your tables change frequently, then you should generate these statistics regularly to ensure the statistics accurately represent the data in the tables.
Oracle generates statistics using the following techniques:
Estimation based on random data sampling
Exact computation
User-defined statistics collection methods

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions