Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Views Performance Issue, 7 millions records

Go down

Views Performance Issue, 7 millions records Empty Views Performance Issue, 7 millions records

Post  sssqllearner Wed Oct 29, 2014 9:46 am

Hi,

I have three views in the DWH. Each view takes approx. around 3 minutes to generate the results. Additionally each view generates 7 millions records. These views are affecting my SSAS cube performance in some or other way.

I have tried many options like using CTE instead of distinct, replace coalesce with isnull and replacing older-style inner joins to regular inner joins. Nothing is helping me to speed up the views. Also the views has 4 blocks of union all. Each block of query runs fine on themselves but when I run the whole view it is very slow as explained above.

Do you have any ideas of how to speed up this or start analysing the issue behind these view?

Regards.
sssqllearner.


sssqllearner

Posts : 8
Join date : 2014-09-16

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum