1 Reply Latest reply: Dec 15, 2013 6:26 AM by vikas mahajan RSS

    GROUP BY PERFORMANCE

    Jonathan Tago

      HI

      I HAVE A VERY BIG TABLE 500 FIELDS 40M ROWS TRYING TO GROUP THIS TABLE AND IT TAKES FOREVER AROUND 8HRS

      ANY IDEAS HOW TO IMPROVE THIS GROUP BY???

      TRIED TO CUT THIS TABLE TO 5 SEPARATE TABLES  THAT HAVE 100 FIELDS AND 40M ROWS AND THEN JOIN BACK ALL 5 TABLES BACK TO ONE THIS DIDN'T IMPROVE THE PERFORMANCE BY MUCH

       

      ANY OTHER IDEAS?

       

       

      THANKS

      JT