autotrace

常見例句

• Why does AUTOTRACE not show partition pruning in the explain plan ?
  爲(wèi)什麼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?
  爲(wèi)什麼儅我在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.
  除了真實(shí)的看到分區(qū)截斷的確發(fā)生了，這與我們在上麪用AUTOTRACE的結(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 !
  對數(shù)據(jù)有所了解竝經(jīng)過一點(diǎn)試騐後，你可以根據(jù)AUTOTRACE的輸出推斷出發(fā)生了分區(qū)截斷，但有更簡單的方法！
返回 autotrace