Re: Slow COUNT + GROUP BY
We added the 'FORCE INDEX' and it improved he time which used to be around 40s.
As for that index.. we have it.
We can't remove the outer query. What you suggest doesn't provide the required response. It'll only count the number of occurrences of every user.
Subject
Views
Written By
Posted
1737
March 20, 2015 07:00AM
781
March 20, 2015 07:55AM
Re: Slow COUNT + GROUP BY
754
March 20, 2015 08:00AM
736
March 22, 2015 04:11PM
715
March 23, 2015 12:46AM
1096
March 23, 2015 02:45AM
996
March 23, 2015 04:30AM
897
March 23, 2015 06:04AM
763
March 23, 2015 08:13AM
771
March 24, 2015 02:02AM
761
March 24, 2015 02:51AM
783
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.