Re: Efficient Score in InnoDB

[Thomas Rice]

Hmm, I just tried a very simple query:

EXPLAIN SELECT id FROM players WHERE id>2000 LIMIT 1

and it returns this:

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE players range PRIMARY PRIMARY 4 NULL 57177 Using where; Using index

It's an InnoDB table and "id" is my primary key.

I was just wondering why it looks through 57177 rows rather than 1?

Adding ORDER BY id DESC or ORDER BY id ASC doesn't seem to help either.

Thanks.