First, the query.
Code: Select all
SELECT id, type, userkey, name
FROM test
WHERE type = 'foobar'
ORDER BY processed ASC
LIMIT 10Code: Select all
CREATE TABLE `test` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`userkey` varchar(100) NOT NULL,
`name` varchar(255) NOT NULL,
`type` varchar(100) NOT NULL,
`entered` datetime NOT NULL,
`processed` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `userkey` (`userkey`)
) ENGINE=MyISAM AUTO_INCREMENT=1924053 DEFAULT CHARSET=latin1;Code: Select all
id select_type TABLE type possible_keys KEY key_len ref rows Extra
1 SIMPLE test range type type 102 NULL 1924050 USING WHERE; USING filesortCan anyone provide insight? Thanks