autotrace

常見例句

Why does AUTOTRACE not show partition pruning in the explain plan ?
為什么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?
為什么當(dāng)我在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ā)生了，這與我們?cè)谏厦嬗肁UTOTRACE的結(jié)果一致。
You can, with a bit of knowledge of your data and a little experimentation, deduce that partition pruning is taking place from the output of autotrace, but there are much easier ways !
對(duì)數(shù)據(jù)有所了解并經(jīng)過一點(diǎn)試驗(yàn)后，你可以根據(jù)AUTOTRACE的輸出推斷出發(fā)生了分區(qū)截?cái)?，但有更?jiǎn)單的方法！