dear all , i make two indexes on a table(as follow) . And i execute the command explain select * from terayon200109.tlcounter200109 d where d.timerecord = '0109012300' to measure the performance. Unfortunately, it seems no any advanatages cover, would U tell me what is wrong ? how to amend that
table type possible_keys key key_len ref rows Extra d ALL timerecordindex 56463703 where used CREATE TABLE tlcounter200109 ( sitename varchar(12), esn varchar(12), cellus int(11), cellds int(11), pktsus int(11), pktsds int(11), timerecord timestamp(10), KEY esnindex (esn, timerecord), KEY timerecordindex (timerecord) ); regards, kmlau --------------------------------------------------------------------- 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
