Siebel Analytics Server Administration Guide > Query Caching >

Query Cache Architecture


The query cache consists of cache storage space, cache metadata, and cache detection in query compilation. Figure 20 shows the basic architecture of the query cache and illustrates how query caching can remove many of the most costly steps.

Figure 20.  Example Physical Table Definitions

Click for full size image

The process of accessing the cache metadata is very fast. If the metadata shows a cache hit, the bulk of the query processing is eliminated, and the results are immediately returned to the user. The process of adding the new results to the cache is independent of the results being returned to the user; the only effect on the running query is the resources consumed in the process of writing the cached results.


 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003