Siebel Analytics Performance Tuning Guide > The Database Servers > Overview of Database Indexing >

Database Optimizers


All the database servers supported by Siebel Analytics have optimizers that generate a set of execution plans and then select the most optimal plan. These optimizers can generate plans based on rules and on processing costs. The cost-based optimizers rely on data distribution statistics stored in the database catalog which much be generated and periodically refreshed by the administrator, but they generally out-perform rules-based optimizers in data warehousing environments.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003