Re: Count(*) query is slower on partitioned table
Posted by:
Rick James
Date: December 12, 2016 01:56PM
Please show us the SHOW CREATE TABLE after "adding a column" and indicate which column was added. If it was something like TEXT, give us a clue of how big it typically is.
And which index does the EXPLAIN say is being used for the COUNT(*)?
Subject
Views
Written By
Posted
8040
December 03, 2016 11:53AM
2454
December 10, 2016 12:30AM
2260
December 10, 2016 06:48AM
Re: Count(*) query is slower on partitioned table
2081
December 12, 2016 01:56PM
2197
December 13, 2016 02:50PM
1986
December 21, 2016 12:35AM
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.