Query performance tuning – Introduction
Query performance tuning is a process of improving system performance to make it faster and more scalable. It is a creative and iterative process which has a clear and well-defined objective. To achieve this goal, we have to follow certain defined steps.
Why we need this
Enterprise data changes frequently over time, which may impact the performance of existing queries. In most of the cases, a slight change in the index or in the query can improve the performance of the query significantly. In such cases, the improvement in performance can be much better than a CPU or memory upgrade.
How to tune a query
Performance tuning process has certain steps to follow in a defined way to achieve the clearly defined objective.
In the above flow chart, you see that we begin by setting objective, followed by getting the current performance … More