建站
咨詢
售后
建站咨詢
新聞中心
DB2 SQL文執(zhí)行計(jì)劃監(jiān)控是DB2數(shù)據(jù)庫(kù)監(jiān)控的重要組成部分，下面就讓我們來(lái)了解一下什么是DB2 SQL文執(zhí)行計(jì)劃監(jiān)控。
我們提供的服務(wù)有：網(wǎng)站制作、成都做網(wǎng)站、微信公眾號(hào)開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、長(zhǎng)葛ssl等。為上千企事業(yè)單位解決了網(wǎng)站和推廣的問(wèn)題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的長(zhǎng)葛網(wǎng)站制作公司
靜態(tài)的sql文執(zhí)行計(jì)劃存放在系統(tǒng)的catalog表中，動(dòng)態(tài)sql文的執(zhí)行計(jì)劃存放在global package cache。
如果要使用explain工具，首先要?jiǎng)?chuàng)建相關(guān)的表，建表腳本在/misc/EXPLAIN.DDL，只要運(yùn)行過(guò)一次explain GUI工具，將自動(dòng)創(chuàng)建這些表。
explain特定注冊(cè)器類型：
CURRENT EXPLAIN MODE - Used to populate only the explain data. No snapshot will be taken.
CURRENT EXPLAIN SNAPSHOT - Used to capture only the explain snapshot data.
設(shè)置explain特定注冊(cè)器類型：
SET CURRENT EXPLAIN MODE option
SET CURRENT EXPLAIN SNAPSHOT option
The explain registers options are:
NO - No explain information is captured for dynamic SQL statements.
YES - Explain tables or snapshot information will be populated for dynamic SQL statements while executing the SQL statement, and the result is returned.
EXPLAIN - Explain tables or snapshot information will be populated for dynamic SQL statements without executing the SQL statement. Use this state to obtain explain information without executing the SQL statement.
文章名稱：DB2SQL文執(zhí)行計(jì)劃監(jiān)控簡(jiǎn)介
網(wǎng)頁(yè)地址：http://m.fisionsoft.com.cn/article/dphejsg.html
