Bookshelf Home | Contents | Index | Search | PDF |
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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Performance Tuning Guide Published: 18 April 2003 |