Re: index questions 2nd request

rick herbel wrote: > Question - Why is key len,ref null ?? Is it not using my key? Why does it > say type range > here and below it says type ref the table has 134000 records in it so it > should be using key. Have you run myisamchk -a on the table? (Or ANALYZE TABLE from the sql prompt?) b.

index questions 2nd request

Questions about index mysql> show index from listing; +-++-+--+-+- --+-+--+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | +-++