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
1750
March 20, 2015 07:00AM
788
March 20, 2015 07:55AM
766
March 20, 2015 08:00AM
742
March 22, 2015 04:11PM
726
March 23, 2015 12:46AM
1102
March 23, 2015 02:45AM
1005
March 23, 2015 04:30AM
906
March 23, 2015 06:04AM
772
March 23, 2015 08:13AM
Re: Slow COUNT + GROUP BY
779
March 24, 2015 02:02AM
768
March 24, 2015 02:51AM
790
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.