The article presents the typical reasons of non-optimal operation of queries diagnosed at the configuration code level and considers the techniques if query optimization.
A significant part of problems that lead to the non-optimal query operation is detected by analysing the configuration code and metadata structure. There is a list of typical errors of the code and data structure whose consequences are fairly well studied and easily predictable. The code analysis using this list allows solving most of the problems with query performance without going into the detailed technical information (query text in the SQL language, query plan, etc.).
Continue reading Typical reasons of non-optimal query operation and optimization methods