06-13-2007, 07:15 AM
|
|||
|
|||
Is there any Difference
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.
    
|
| Sponsored Links |
|
06-16-2007, 04:56 PM
|
|||
|
|||
|
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.
|
 |
| Bookmarks |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| difference between emulator and debugger | Rani_2006 | Tech FAQ | 0 | 05-29-2007 04:13 PM |
| difference between winrunner 7./7.6 | zecar | Software Testing | 1 | 11-13-2006 02:32 AM |
| Linux vs. Windows web Hosting, does it make a difference? | sanereddy | Unix Articles and Tutorials | 7 | 04-23-2006 01:39 PM |
| comp.lang.c Answers to Frequently Asked Questions (FAQ List) | Steve Summit | Tech FAQ | 0 | 06-01-2004 06:00 AM |
| Smalltalk FAQ (v.1.0) | Vikas Malik | Tech FAQ | 0 | 04-17-2004 07:27 AM |
All times are GMT -4. The time now is 07:40 PM.
