i am new to mysql. i have got a table tab1 in my database. i am using 4.0.3 version of mysql and the table type is MyISAM. the tab1 has got 14 fields and about 600,000 records and is indexed on col1 which is of varchar type
i have used the query select * from tab1 order by col1; which does not use the index. when i used explain select * from tab1 where col1 > 'const'; -- (const is a valid constant for col1) it gave col1indx in 'key' column but in the 'extra' column i did not get 'using index' instead i got 'using where' only. does it mean that it is not using index? the output of this query is less than 1% of the entire table. how can i make the queries above to use the index? i have used the use index and force index but found out that they are not useful. thanks in advance. Prasanth --------------------------------------------------------------------- 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
