Is there any Difference

[rachelle]

In our company we were previously using oracle 9i and now we have switched to oracle 10g .The question I have is with respect to analyzing statistics in database. I want to know whether there is any difference in analyzing statistics of database with respect to oracle 9i and oracle 10g.If so what it is. Someone kindly give brief idea on this.

[Rahulbatra]

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.