我希望上面的示例和分析证明是对您有所帮助的,并希望本文能充当SQL查询调优的简介。
I hope the above examples and analysis prove to be be helpful and serve as an introduction to SQL query tuning.
在大多数用例中,这是理想的行为,并被视为一个调优问题:增加maxdepth值,直到队列能吸收最高峰值负载。
In most cases, this is the desired behavior and is treated as a tuning problem: increase MAXDEPTH until the queue can absorb the highest peak loads.
性能调优的目的是尽可能为优化器提供最好的输入,以便优化器能选择最好的访问路径。
The purpose of query tuning is to provide the best possible input to the optimizer so that the optimizer can choose the best access path.
应用推荐