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.
在编译语句时,语句的访问计划被存储在包缓存中。
应用推荐