Avoiding deadlocks | Reduce the result set as early as possible


12.3 Performance best practices for SQL queries

Optimizing SQL is an extensive, multidimensional topic and requires careful analysis of not only the SQL but also the data and the scenarios using that data.

Here we list some of the key aspects of SQL optimization only that we found beneficial when writing code for WebSphere Commerce.