本文详细介绍了Oracle AutoTrace的多种选项，包括如何显示执行计划、统计数据及预期返回的行数等，帮助理解并优化SQL查询。
Oracle autotrace supports the following options:
• autotrace on - Enables all options.
• autotrace on explain - Displays returned rows and the explain plan.
• autotrace on statistics - Displays returned rows and statistics.
• autotrace trace explain - Displays the execution plan for a select statement without actually executing it. "set autotrace trace explain"
• autotrace traceonly - Displays execution plan and statistics without displaying the returned rows. This option should be used when a large result set is expected.
扫一扫
520
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
