7 Replies Latest reply: Mar 20, 2013 7:29 AM by Kaushik Solanki RSS

    DLP optimization - not accaptable query execution time

    Michael Ionkin

      Hello

       

      I've build a report, but unfortunatly the query execution time is just too long - over one minute.

      I've tried already to optimize the model, but without any success.

       

      The biggest table I have is about 500'000'000 rows. And I have tested following models:

       

      Model1

      Model2:Model 1.png

      Model 2.png

       

      The last thing which might help is to join calendar to the fact table...

      Otherwise I see only the way to split the table in different parts and create different reports.

       

      Actually I did it already and split it in years, but the execution time is only acceptable when I split it in 4 month periods (execution time around 8 sec).

       

       

      What can I do in order to optimize the model/report/execution time???

      Any ideas?

       

       

      cheers chesterluck