From: "Pavel Novak" > | 1 | SIMPLE | o | ALL | NULL | NULL | NULL > | NULL | 20402 | Using temporary; Using filesort |
Well, this is a clue IMHO... no suitable indexes in o could be found to use in this query... Since you use a lot of columns from orders, you'll probably need an index that contains all the columns from orders that are used in the query, or at least an index that can be used for the slowest join. Furthermore you sort on orders.id, so this field should be included in the index. Creating the right indexes and putting the parts of the query in the right order with the help of the output from explain, can make a slow query fly! Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]