mysql not using indexes if select * where a 5

Hi, I found that mysql doesn't used indexes if there is a in the where statement... for example mysql explain select * from testtable where id 5; +-+--+---+--+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows |

Re: mysql not using indexes if select * where a 5

On Thursday, 21. February 2002 12:46, Natalino Picone wrote: Hi, I found that mysql doesn't used indexes if there is a in the where statement... for example mysql explain select * from testtable where id 5; It would only make sense to use an index, when you want to select the id field

mysql not using indexes if select * where a 5

Natalino, Thursday, February 21, 2002, 1:46:11 PM, you wrote: NP Hi, NP I found that mysql doesn't used indexes if there is a in the where NP statement... NP for example NP mysql explain select * from testtable where id 5; NP