MySQL 5.6 Release Notes
MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, and index hints.
User Comments
Posted by
Richard Prout
on
July 30, 2008
I had a view with probably 20 joins in. tables typically only had 100 rows. query would initially take 20-30seconds. i set the optimiser search depth down to 3 and got that time down to 90ms.