With the step-by-step analysis on statistics, predicate, and index, theperformanceof the problem query is improved significantly.
通过对统计数据、谓词和索引的逐步分析,问题查询的性能大幅提升。
2
Add comments to theindex to indicate why it was created, for example, to help theperformanceof transaction XYZ.
添加关于索引的注释,指示创建的原因,例如,用于帮助提高事务xyz的性能。
3
In fact, the use of an index for sort avoidance is a key way to improve theperformanceof SQL that qualifies far more rows than will actually ever be FETCHed.