Hi, I have a question about Mysql database optimization.
I have a table "t1", which has an index "id". but when i execute "EXPLAIN SELECT * from t1 order by id" in phpmyadmin I got the following results:
table type possible_keys key key_len ref rows Extra
t1 ALL NULL NULL NULL NULL 1078 Using filesort
Does this mean that this simple SELECT is very slow since it is not using the index at all?