2 Replies Latest reply: Apr 2, 2014 11:28 PM by Khim Hoe Tan RSS

    Improve Aggregation Performance

      Hi all,

       

      I have a table containing 20mils rows of data. To improve the performance, I decided to aggregate (sum, avg, etc) the table to higher level. But the time needed to do the aggregation is very long (without aggregation is around 10 mins, with aggregation is around 1 hour). Is there a way/trick to speed it up?