kmlau wrote: > I encountered a problem about indexing. I want to add index on timerecord > field in table gw (shown as below) to speed up query relating with time. > However, I use explain command (explain select * from gw where timerecord = > '0109020000') to analyze the performace. As a result, it seems the query do > not use this index. Would U tell me why and how to correct this !!
U do not need to specify the timestamp as a string, e.g. remove the quotes: timerecord=109020000. But more importantly run 'myisamchk -a' on the index (.MYI) file. Doing both of these will help. 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