http://www.mysqlperformanceblog.com/2006/07/24/extended-explain/

CommentFileSizeAuthor
#1 dbtuner-933958.patch2.63 KBmikeytown2

Comments

mikeytown2’s picture

mikeytown2 commented
Status: Active » Needs review
StatusFileSize
new dbtuner-933958.patch2.63 KB
dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented

I've never quite understood the value of extended explain. It can be interesting when you're first starting out to see how MySQL rewrites your query before execution. But can you actually infer something from the results that you need to change?

mikeytown2’s picture

mikeytown2 commented

Interesting use case: http://www.chriscalender.com/?p=118 but if you have all collations set to the same then it's not as critical. For views this isn't as big of a deal; running it on the slow query log (something that is yet to be implemented) could be beneficial.