MySQL Indexes Explained: How to Read EXPLAIN and Fix Slow Queries
A slow query is usually a missing or mismatched index. Learn to read MySQL 8's EXPLAIN output, order composite index columns correctly and verify the fix.
Databases
SQL Window Functions in MySQL 8: Running Totals, Rankings and Top-N per Group
Stop exporting to spreadsheets. MySQL 8 window functions handle running totals, rankings and month-over-month growth in one readable query.