Contact MySQL | Login | Register
[+/-]
MySQL provides optimizer control through system variables that affect how query plans are evaluated and which switchable optimizations are enabled.
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.
© 2015, Oracle Corporation and/or its affiliates
User Comments
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.