MySQL Forums
Forum List  »  MyISAM

Re: Almost whole table in single index: is there a better way?
Posted by: Aftab Khan
Date: August 27, 2012 09:18AM

Can we see EXPLAIN output of the following SQL please?

EXPLAIN SELECT SensorTime,Value FROM RemoteStatuses WHERE RemoteID = X AND DataID = Y AND SensorTime BETWEEN A AND B \G

You may convert this table to InnoDB, primary key would be used a clustered index. Accessing a row through the clustered index is fast because the row data is on the same page where the index search leads.

What version of MYSQL are you using?

Options: ReplyQuote

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.