You are managing the following database system:
• DBMS: Oracle 11g
• OS: Sun Solaris
• System architecture: Web-based application using ASP.Net
• Purpose of Server: HR management
• Total size of database: 120 MB
• Total number of table: 12
• Total number of index including Primary Key: 18
• Daily average number of transactions: 400
• Complexity of SQL: simple
• Update: not frequently
As a database administrator, you need to decide query optimizer, i.e., CBO (Cost-based
optimizer) or RBO (Rule-based optimizer).
Which one are you going to select for your system? Any Why?