Tag Archives: Query

Typical reasons of non-optimal query operation and optimization methods

Publications: Typical reasons of non-optimal query operation and optimization methods
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

Use of characteristics in Data composition schema (DCS).

In the query builder, when it is called from the form of data source configuration, there is a tab “Characteristics” for the data composition schema the use of which is not distinctly described in the documentation. In this article I will try to explain how and for what the characteristics are used in the DCS.
Continue reading Use of characteristics in Data composition schema (DCS).