MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Index causing much slower query
Posted by: Benoit St-Jean
Date: October 03, 2008 10:07AM

Perhaps the index with (intcol, datetimecol) is too big to fit in memory while the other index (intcol) fits in memory?

Besides, have you tried subpartitionning on the datatimecol ? I'd be curious to see if that would help.

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


Subject
Views
Written By
Posted
Index causing much slower query
5502
H M
September 04, 2008 12:07PM
Re: Index causing much slower query
2818
Robert Freeland
September 04, 2008 12:14PM
Re: Index causing much slower query
2833
H M
September 04, 2008 12:36PM
Re: Index causing much slower query
2856
Benoit St-Jean
October 03, 2008 10:07AM
Re: Index causing much slower query
2865
Scott Noyes
October 08, 2008 07:46AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.