If the same INSERT statement is executed repeatedly, its access plan will (usually) be found in the package cache and the compilation cost is avoided.
如果重复地执行相同的insert语句，则该语句的访问计划(通常)会进入到包缓存中，这样就免除了编译的开销。
It can also capture queries from SQL cache and produce the explain plan.
它还可以从SQL缓存捕获查询并生成解释计划。
So when the same SQL statement is executed again, DB2 finds the previously created access plan in the statement cache and reuses the access plan.
因此，当同一个sql语句再次执行时，DB 2在语句缓存中找到此前创建的访问计划并重用它。
The DB2 optimizer stores the access plan created in the prepare phase in the SQL statement cache (also called package cache in DB2) for reuse purposes.
DB 2优化器将准备阶段中创建的访问计划存储在sql语句缓存(在DB 2中也称为包缓存)中以便重用。
My plan is to load the entire CDA and transform it, then allow interactive access through the DOM so that I have a div element called div-cache, which I have hidden at the bottom of the viewer.
我的计划是加载并转换整个CDA，然后允许通过DOM进行交互式访问，这样我就能拥有一个名为div-cache 的 div元素，我将该元素隐藏在 CDA Viewer底部。
SQE is the strategic query engine on DB2 for I, with better performance, scaling and tooling such as the SQL Plan Cache.
SQE是DB 2fori上的战略性查询引擎，具有更好的性能、可伸缩性和工具，例如SQLPlan 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功率，且终端用户请求的性质每一次可能不同，使用QueryPlan Cache就没有意义。
Typically, plan for a cache storage capacity of several gigabytes on disk, as well as at least 128 MB of RAM, preferably gigabytes of RAM.
通常，应该在磁盘上规划几千兆字节的高速缓存存储容量，内存至少应该有128MB，最好有几千兆。
Typically, plan for a cache storage capacity of several gigabytes on disk, as well as at least 128 MB of RAM, preferably gigabytes of RAM.
通常，应该在磁盘上规划几千兆字节的高速缓存存储容量，内存至少应该有128MB，最好有几千兆。
应用推荐