autotrace
基本解释
- n. 自動跟蹤;自動描圖;電氣液壓靠模倣型銑牀
英汉例句
- Why does AUTOTRACE not show partition pruning in the explain plan ?
爲什麽AUTOTRACE不會在執行計劃中顯示分區截斷(partition pruning)? - Autotrace's output is not showing partition elimination.
AUTOTRACE的輸出沒有顯示分區截斷。 - Why is it that when I use AUTOTRACE in SQL*Plus, the explain plan never shows partition pruning taking place?
爲什麽儅我在SQL*Plus中使用AUTOTRACE時,執行計劃從不顯示發生了分區截斷呢? - SQL>set autotrace on;select * from t1 where object_type=:b0;SP2-0552: Bind variable "b0" not declared.
不輸入綁定變量的數值我如何看這條語句的執行計劃呢? - This is identical to what we saw above with autotrace, except we get to see that partition pruning did actually take place.
除了真實的看到分區截斷的確發生了,這與我們在上麪用AUTOTRACE的結果一致。
词组短语
- set autotrace 選項
- SET AUTOTRACE ON 開啓
- set autotrace traceonly 查看執行計劃;與ON相似
- set autotrace traceonly explain 衹顯示執行計
- set t autotrace 使用步驟