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的输出推断出发生了分区截断,但有更简单的方法! 返回 autotrace