Alternate Hierarchy Impacting SmartView Performance
We recently added an alternate hierarchy - includes majority of our entities in our main hierarchy excluding 8. When this alternate hierarchy was added, we noticed a drastic change in our SmartView retrieval times. In some cases, the query was timeout. Has anyone seen this happen before?
Alternate hierarchy is negatively impacting SmartView retrieval
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):