In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes: > Have you considered splitting this into two queries? One query can gather > information from your token and token_ins tables. The other would join the > first queries results to the other tables to complete your original query. > Depending on your data, one of these subqueries should return a smaller > set (fewer rows) and you should execute the smaller one FIRST. Because of > that you may want to flip the order of execution of these queries around > (modifying as appropriate for the new order) and check the cd, c, and d > tables first and join those results to the t, ti, t2 and ti2 tables.....
Yes, this might help. BTW, you don't need a temp table for that. MySQL allows controlling the join order by STRAIGHT_JOIN. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
