Siebel Analytics Performance Tuning Guide > Siebel Analytics > Enable Query Caching >

Benefits

Query caching is similar to the technique used by database servers to rewrite queries to use precomputed results stored in aggregate tables. The advantage of query caching is that Siebel Analytics answers the query from its cache instead of forwarding it on to the database server for processing. Note that query caching still takes full advantage of query rewrites by the database on the first time the query is issued.

Query caching actually extends beyond a single query to the class of queries that can make use of the cached results. For example, Siebel Analytics can use the cached result set for queries that require a qualified subset of the cached results. Thus, a single cached result set can improve the average response time of a family of similar queries.

Query caching also conserves network resources and processing time. The demand on the network is reduced because intermediate results do not need to be transferred over the network to Siebel Analytics. The demand of the database server and computer host is reduced because the query workload has been reduced. Therefore the efficiency of query caching improves query performance and increases the capacity of computer and network resources.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003