This content has been marked as final. Show 7 replies
There are couple of things I can suggest.
1) Create materialized views for that face table in database and then try to use
2) First test if its actually the issue with calculated measures or some other reason. You can do this by running the report by removing those 4 calculated columns.
3) If possible try to split the report into two reports and do a union.
mark helpful/correct if it helps
Thanks for your valuable suggestions.. I found that, Calculated columns are not the issue, i have removed those calculated columns and checked but still the query runs long..
And I have some limitations..
Working on OLTP
Dont have Cache Concept
Tables(has lakhs of records for even a single month) used are normal Views.
So the option for me would be creating an MV ??? or any other options ??
If i create an MV then its gonna improve the query performance ??