Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you post script and purpose of joining tables ?
Vikas