How many processing-intensive SQL statements should be taken into account in SQL optimization?
There is no single, general response to this question. The answer depends primarily on the corresponding rows of optimization and the current system status. For example, in one case, the optimization of an individual extremely processing-intensive SQL statement may ensure that a system that could previously hardly be used runs optimally again, whereas in another, more than 50 SQL statements must be optimized, to achieve the desired performance improvements. Indicators regarding whether a system is already well tuned or not are outlined in Note 819641.
