SQE is the strategic query engine on DB2 for I, with better performance, scaling and tooling such as the SQL Plan Cache.
SQE是DB 2 for i上的战略性查询引擎,具有更好的性能、可伸缩性和工具,例如SQL Plan Cache。
For example, if the environment does not have a lot of CPU power and the nature of the end user requests are most likely different each time, using the Query Plan Cache would not make sense.
例如,如果环境没有大量cpu功率,且终端用户请求的性质每一次可能不同,使用Query Plan Cache就没有意义。
When the statement is compiled, its access plan is stored in the package cache.
在编译语句时,语句的访问计划被存储在包缓存中。
应用推荐