autotrace

基本解釋

Why does AUTOTRACE not show partition pruning in the explain plan ?
爲(wèi)什麼AUTOTRACE不會(huì)在執(zhí)行計(jì)劃中顯示分區(qū)截?cái)啵╬artition pruning）？
Autotrace's output is not showing partition elimination.
AUTOTRACE的輸出沒有顯示分區(qū)截?cái)唷?/li>
Why is it that when I use AUTOTRACE in SQL*Plus, the explain plan never shows partition pruning taking place?
爲(wèi)什麼儅我在SQL*Plus中使用AUTOTRACE時(shí)，執(zhí)行計(jì)劃從不顯示發(fā)生了分區(qū)截?cái)嗄兀?/li>
SQL>set autotrace on;select * from t1 where object_type=:b0;SP2-0552: Bind variable "b0" not declared.
不輸入綁定變量的數(shù)值我如何看這條語句的執(zhí)行計(jì)劃呢？
This is identical to what we saw above with autotrace, except we get to see that partition pruning did actually take place.
除了真實(shí)的看到分區(qū)截?cái)嗟拇_發(fā)生了，這與我們在上麪用AUTOTRACE的結(jié)果一致。