|List:||General Discussion||« Previous MessageNext Message »|
|From:||Philip Brown||Date:||October 6 2001 8:48am|
|Subject:||RE: Bizarre query performance|
|View as plain text|
> 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?