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 使用步骤