Siebel Analytics Performance Tuning Guide > Siebel Analytics > Add Aggregate Tables >

Packaged Aggregate Tables

Siebel eBusiness Data Warehouse includes several packaged aggregate tables to speed-up query performance. Aggregate tables are precomputed answer sets which are one of the most effective means to improve query performance. Siebel Analytics can substitute in place of detail tables to improve query performance. The server makes this substitution by rewriting the query, an operation that is transparent to the user. Aggregate tables are similar to indexes: the server, not the user, determines whether to use the aggregate table, and the decision rests on the expected performance improvement.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003