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在语句缓存中找到此前创建的访问计划并重用它。
When the statement is compiled, its access plan is stored in the package cache.
在编译语句时，语句的访问计划被存储在包缓存中。
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语句，则该语句的访问计划(通常)会进入到包缓存中，这样就免除了编译的开销。
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中也称为包缓存)中以便重用。
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，最好有几千兆。
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。
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。
应用推荐