Performance problems when filtering and excluding hierarchy node

[Former Member]

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?!

Thanks,

Andreas

[Former Member · Accepted solution]

Hi Andreas,

I had read in one of the performance Docs that,

"Inclusion gives better performance than exclusions.."

Never tried it but you can check if there is any performance improvement by including the nodes you need rather than excluding the one you don`t need..

Let me know..

Ashish