MySQL Forums
Forum List  »  Partitioning

Re: Index causing much slower query
Posted by: H M
Date: September 04, 2008 12:36PM

Robert Freeland Wrote:
-------------------------------------------------------
> I'd love to hear an explanation for this myself.
> In some of our tests, it almost seemed like the
> order of the keys in the index was inverted.
> Assuming you don't have a separate index on
> datetimecol, how snappy is a query using that in
> your WHERE clause?

Hi,

We do not have an index on just datetimecol. A query matching only against datetimecol does not seem to be any faster than I would anticipate it taking on my table.

Options: ReplyQuote


Subject
Views
Written By
Posted
5029
H M
September 04, 2008 12:07PM
2615
September 04, 2008 12:14PM
Re: Index causing much slower query
2628
H M
September 04, 2008 12:36PM
2653
October 03, 2008 10:07AM
2676
October 08, 2008 07:46AM


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.