Search SSWUG.ORG:

DATABASES

Pager script for shrinking EXPLAIN output This is an off-site link.  Please review our Terms of Service for additional information.




(Sergey Petrunia) Everyone who works with MySQL (or MariaDB) query optimizer has to spend a lot of time looking at EXPLAIN outputs. You typically first look at the tabular form, because it is easier to read. You can immediately see what the join order is, what numbers of records will be read, etc:

Read this article...







comments powered by Disqus