Re: Almost whole table in single index: is there a better way?

[Aftab Khan]

>EXPLAIN SELECT SensorTime,Value FROM RemoteStatuses WHERE SensorID = 525 AND DataID = 110 AND SensorTime BETWEEN 1346083196-86400*7 AND 1346083196

SQL looks different from the original SQL?

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

> RemoteID vs SensorID
Column SensorID doesn't exist in provided table structure?

CREATE TABLE `RemoteStatuses` ( 
`RemoteID` int(11) NOT NULL, 
`SensorTime` int(11) NOT NULL, 
`DataID` smallint(6) NOT NULL, 
`Value` char(8) NOT NULL, 
PRIMARY KEY (`RemoteID`,`DataID`,`SensorTime`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1