How Can You Manage Optimizer Statistics?

1.	How Can You Manage Optimizer Statistics?
Answer» You can manage optimizer statistics through the dbms_stats package. This package OFFERS multiple functions or procedures to gather, modify and REMOVE statistics. Statistics stored in the dictionary have an impact on the COST BASED optimizer. You can also use the dbms_stats PROCEDURE to gather statistics in parallel.

Answer»

You can manage optimizer statistics through the dbms_stats package.
This package OFFERS multiple functions or procedures to gather, modify and REMOVE statistics.
Statistics stored in the dictionary have an impact on the COST BASED optimizer. You can also use the dbms_stats PROCEDURE to gather statistics in parallel.

Discussion