Re: Slow COUNT + GROUP BY
Hi,
Another idea that comes to mind: The uid column is pretty long. This means that the amount of memory needed by the data structure that stores unique values may become so large that intermediate storage on disk is needed. You could increase available memory for this data structure by increasing the settings for the variables tmp_table_size and max_heap_table_size. (Both needs to be increased in order to see an effect.)
Subject
Views
Written By
Posted
1741
March 20, 2015 07:00AM
784
March 20, 2015 07:55AM
757
March 20, 2015 08:00AM
740
March 22, 2015 04:11PM
718
March 23, 2015 12:46AM
1099
March 23, 2015 02:45AM
999
March 23, 2015 04:30AM
899
March 23, 2015 06:04AM
765
March 23, 2015 08:13AM
Re: Slow COUNT + GROUP BY
774
March 24, 2015 02:02AM
764
March 24, 2015 02:51AM
786
March 24, 2015 03:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.