MySQL Forums
Forum List  »  MyISAM

Re: How to enable index fast in MyISAM table
Posted by: Rick James
Date: March 23, 2014 02:36PM

> explain showes it use correct process_sid index.
> KEY `process_sid` (`process_sid`,`action`),
> select xxx from servicetable where process_sid="xxx" and action in (xxx, ...) order by session_seq

That index is optimal for that query.

> explain partitions select count(*) from servicetable where timestamp>"2014-03-21 00:00:00" and timestamp<"2014-03-22 00:00:00" and date="2014-03-21";

That failed to say "Using index". File a bug at bugs.mysql.com

I do not know if it matters that `date` and `timestamp` are NULLable, but it might.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to enable index fast in MyISAM table
1630
March 23, 2014 02:36PM


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.