autotrace

常見例句

• Why does AUTOTRACE not show partition pruning in the explain plan ?
  爲(wèi)什麼AUTOTRACE不會在執(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é)果一致。
• 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ū)截?cái)?，但有更簡單的方法?/li> 返回 autotrace