10 Replies Latest reply: Oct 23, 2015 5:58 AM by Sergey Makushinsky RSS

    S...L...O...W..... Min/Max

    Chris Kelley

      I have the below calculation running against a "telemetry" data set. That data set is about 300 million rows, and all time-series.

       

      LOAD  
                     min([CalendarDate]) as minDate,  
                     max([CalendarDate]) as maxDate  
      Resident telemetry;
      
      
      
      

       

       

      Any thoughts on how to get the above query (or alternative) to run in say a couple of minutes or less instead of many hours?

       

      Clarification: the above slowness occurs even if the number of records is limited to say 30M. The last run was, I believe, over 6 hours long.

       

      Message was edited by: Chris Kelley