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.
Procedure
1:1 indicates the <Minimum>:<Maximum> hierarchy level. The minimum depth of hierarchy defines the hierarchy level the query should start analyzing. The maximum depth of hierarchy defines the maximum number of levels in the structure to be analyzed. You can use any value from 0 to infinity (*). If you select 0 for Minimum and Maximum the query is executed as a query without defined hierarchy depth. To see the very last item in the hierarchy you can enter * for minimum and maximum depth of hierarchy. Analyzing a deep hierarchy may cause low performance.
Using the United Motor Group demo database, this query returns the following result:
The result is displayed in the defined layout once the query has completed. You can display the result in different ways.