Query too slow

[Lorenzo De Vito]

I've this query that is too slow, how can I  optimize this sintax ?

SELECT * FROM table_1
INNER JOIN table_2 ON ID_table_2=table_1_ID
INNER JOIN table_3 ON ID_table_3=table_2_ID
INNER JOIN table_4 ON ID_table_4=table_3_ID
INNER JOIN table_5 ON ID_table_5 = table_4_ID
INNER JOIN table_6 ON ID_table_6 = table_5_ID
WHERE ID_table_2 > 1000
AND ID_table_5 > 700;


---------------------------------------------------------------------
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