Setting optimizer search depth in MySQL

(Max) A customer of ours had an interesting problem regarding a query that was taking too long, around 55s. Looking at the query with the query profiler we found that it was spending most of its time in the “statistics” phase.

Read More - Register for Free Membership