|
Yes there is definitely difference in analyzing statistics of database with respect to oracle 9i and oracle 10g. In oracle 9i for analyzing and decision making of how and which to choose and run queries also called as optimizers in short there were two programs used. They are called as rule-based optimizer and cost-based optimizer. As the name implies rule optimizers uses rules for analyzing and analyzing queries whereas cost-based optm9iser uses statistics generated on tables for analyzing of query process. Oracle 9i uses both but oracle 10g uses only cost-based optimizer which makes the query analysis process more efficient.
|