MySQL Forums
Forum List  »  Partitioning

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(*)?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Count(*) query is slower on partitioned table
358
December 12, 2016 01:56PM


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.