MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Slow query on partitioned tables with over 200M rows
Posted by: Øystein Grøvlen
Date: February 12, 2014 01:48AM

Hi Hong Yang,

What did the query and the EXPLAIN plan look like for the query when you "replaced the search criteria raw.fc_ts range with a specific fct_ts value"?

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Slow query on partitioned tables with over 200M rows
2648
Hong Yang
February 11, 2014 05:10PM
Re: Slow query on partitioned tables with over 200M rows
946
Øystein Grøvlen
February 12, 2014 01:48AM
Re: Slow query on partitioned tables with over 200M rows
1017
Hong Yang
February 12, 2014 08:33AM
Re: Slow query on partitioned tables with over 200M rows
1078
Rick James
February 12, 2014 08:47AM
Re: Slow query on partitioned tables with over 200M rows
980
Hong Yang
February 12, 2014 09:59AM
Re: Slow query on partitioned tables with over 200M rows
1139
Rick James
February 12, 2014 02:31PM
Re: Slow query on partitioned tables with over 200M rows
1101
Hong Yang
February 12, 2014 02:53PM
Re: Slow query on partitioned tables with over 200M rows
1344
Rick James
February 12, 2014 04:33PM
Re: Slow query on partitioned tables with over 200M rows
1062
Hong Yang
February 12, 2014 06:41PM


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.