Skip to Content
Former Member
Jul 22, 2005 at 08:59 AM

Performance problems when filtering and excluding hierarchy node


Dear all,

I setup a query with a hierarchy linked to it, where I use a "hard-filtered" exclusion on this hierarchy for a specific node AND a variable which the users can use for flexible filtering purposes.

When I execute the query, the runtime of this query is unimaginable high and I really doubt, whether the underlying SQL-Statement is executed (or generated) correctly. Before I start tracing everything I want to know, whether you encountered some similar problems with such kind of selection and de-selection in a query?!