I need to retrieve 13 rows from a 100,000-row JOIN, starting with a row
with given values.
All required indexes are available AFAICT, yet EXPLAIN tells me mysql is
"Using index; Using temporary; Using filesort" on the first table it's
I don't know where I'm going wrong, or whether I'm hitting a limitation
of mysql's query optimizer. Any help appreciated.
mysql version is 5.0.15.
Tables are set up like this:
-- Main categories. An ID and a name.
CREATE TABLE main (
PRIMARY KEY (id),
KEY name (name)
) TYPE = InnoDB;