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. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php