RE: Bizarre query performance

[Philip Brown]

> The fact that the explain didn't say "Index used".

OK, I am not familiar enough with the information from explain, I thought
that by saying "possible keys=PRIMARY and "key=PRIMARY", the actual index
would be used.

In that case, this begs the question, why does this query:

SELECT * FROM X WHERE ID=1;

where ID is defined as INTEGER PRIMARY KEY, does the query execution not
use the index?