autotrace

基本解釋

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