For queries, it is easy to define a hierarchical depth to be taken into account for analyzing database content. Using the Hierarchy tab, you can define query items to be analyzed recursively. In order speed up the runtime of a query, you can define the hierarchical level of the elements to be analyzed. If you reduce the hierarchy level, fewer database elements are processed. Thus, it takes less time for the query result to be displayed.
Values for minimum depth of hierarchy.
The minimum depth of hierarchy defines the hierarchy level the query should start analyzing.
The value depends on the value set for Maximum. The Minimum value must be less than or equal to the Maximum value. Settings will be corrected automatically.
You can use any value from 0 to n. If you select a lower value for Maximum the Minimum value is set automatically. If you select 0:0, the query is executed as a query without defined hierarchy depth. Analyzing a deep hierarchy may cause low performance.
Values for maximum depth of hierarchy.
The maximum depth of hierarchy defines the deepest level in the structure to be analyzed.
The value depends on the value set for Minimum. The Maximum value must be greater than or equal to the Minimum value. Settings will be corrected automatically.
You can use any value from 0 to infinity (*). To see the very last item in the hierarchy you can enter *. Analyzing a deep hierarchy may cause low performance.
All relevant connections important for the hierarchical processing for the selected item are displayed.
You can expand and
collapse the bullets.