Performance Issue: Gathering Statistics- dbms_stats

What are the advantages of Gathering Statistics?

Showing Answers 1 - 2 of 2 Answers


  • 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

Shivam Softa

  • Sep 19th, 2018

Helps Oracle engine to create better execution plan to execute the query.

  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