> 1. MySQL only uses one index for each table in a JOIN; this query only uses > one table, so only one index is used. > 2. DESC is slower than ASC > 3. Try creating an index on two columns; try cat and date, and try date and > cat. > 4. Check EXPLAIN SELECT id,name...... to see whether the right index is > used.
Thanks for yoiur answers. I only need to order by date to return the latest results and this is why I am using an index for date and one for cat since I am using it in the where condition... Do you think that combining those indexes would make it faster because I am not so sure about that... I know that desc is slower than asc but I also know that SQL server has a specific index for this so I was wondering if MySQL has something similar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
