Neoview Control Query Default (CQD) Reference Guide (R2.5)

You should be aware that the cache allocated is divided into text caching and template
caching. Text caching gets approximately 25% of the cache memory. Query plan caching
occurs prior to parsing (text-based caching) and after parsing (template-based caching).
The compiler caches same-text queries as text cache hits. Same-text queries are queries
whose SQL texts are identical in everything, including case and white space. By caching
text-based queries, the compiler avoids redundant re-computation of previously compiled
queries and improves performance by reducing compile times and increasing compiler
throughput. The text cache is always searched first for a query. If the plan object is not
produced due to a text cache miss, the plan is stored in the template cache if it meets the
criteria for template caching.
Conflicts/Synergies
Not applicableAddressing the real
problem
Neoview Release 1.0Introduced in release
Not applicableDeprecated in release
58 Compiler Cache