Calculate average of large data




I am trying to calculate avg for 10 gb data and show it on graph in browser. Query takes around 16 sec. For smaller chunk of data, it is around 1 sec. Should I divide the table into multiple partitions and run queries in parallel. Or Am I missing something.





  • Options
    emorenoemoreno Employee

    Can you show the explain plan of the statement that you are trying to do the average? Do 


    explain select avg(xxx)..... 


    I would like to see if you have specific aggregatons and the projections that you are using. 



  • Options



    Thanks for your reply, It is simple query for calculating moving average. The query time is now less than 1 sec. I took the help of db designer and it asked me to create a new projection.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file