Hi all. Im triyng to see if i can improve the performance of a query
(mainly a 10 table join)
1) Besides of triyng to use indexes, there is some rules of thumb to follow?
2) Should i try to join the bigger tables last in the query?
3) There is some place for understanding EXPLAIN better?
Thanks!
Gerardo