MySQL Forums :: Partitioning :: Count(*) query is slower on partitioned table


Advanced Search

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
Count(*) query is slower on partitioned table 533 Darren Demicoli 12/03/2016 11:53AM
Re: Count(*) query is slower on partitioned table 183 Rick James 12/10/2016 12:30AM
Re: Count(*) query is slower on partitioned table 227 Darren Demicoli 12/10/2016 06:48AM
Re: Count(*) query is slower on partitioned table 185 Rick James 12/12/2016 01:56PM
Re: Count(*) query is slower on partitioned table 212 Darren Demicoli 12/13/2016 02:50PM
Re: Count(*) query is slower on partitioned table 156 Rick James 12/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.