autotrace

常见例句

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的结果一致。
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 !
对数据有所了解并经过一点试验后，你可以根据AUTOTRACE的输出推断出发生了分区截断，但有更简单的方法！