在这一步中，需要使用上面讨论的工具来获取该查询的统计数据：其响应时间、详细的执行计划和成本，以便稍后进行深入分析。

At this step, you need to use the tools discussed above to get statistics on the query: its response time, its detailed execution plan, and costs for later in-depth analysis.

youdao

此外，还将讨论优化器的角色，其中包括OPTCOMPIND参数、查询命令和内部统计数据。

In addition, it discusses the role of the optimizer, including the OPTCOMPIND parameter, query directives, and internal statistics.

youdao

通过对统计数据、谓词和索引的逐步分析，问题查询的性能大幅提升。

With the step-by-step analysis on statistics, predicate, and index, the performance of the problem query is improved significantly.

youdao