Forum Discussion
Union and Merging Slowing Performance Terribly
Hello All, I have a report which is using 20 SQL views and I am doing few transformations on each, then disabling their load and then creating a UNION of all 20 (the business need is in such a wa...
Are you importing the entire dataset and then making transformations? If yes, then it will give you slower performance. You can write a SQL query and import the transformed data. It will give you much faster results.
- I am refrencing each view individually and navigating to that view alone and then performing the needed transformations on each view.
