Query Plan Decoded - Read EXPLAIN Output in 30 Minutes

Most slow queries aren't mysterious. The database is telling you exactly what it's doing wrong. You just need to know how to read it.

Query Plan Decoded walks you through EXPLAIN output in MySQL, PostgreSQL, SQL Server, and Oracle.

Same query, same slow scan, fixed in each database step by step. About 30 minutes of screen recording. No fluff, just an easy-to-understand explanation of the execution plan for each vendor.

Frequently Asked Questions

Do I need to watch all 8 videos?

No. Each video is self-contained. If you only use PostgreSQL, watch the two PostgreSQL videos.

The format is the same across all four vendors, so if you work with multiple databases, you'll find the other videos easy to follow.

What experience level is this for?

It's aimed at developers who write SQL regularly but haven't spent much time with query plans. If you know what a JOIN is and you've seen slow queries, you're ready for this.

Does it cover query tuning beyond adding indexes?

Not in depth. The focus is on reading the plan and understanding what each step is about. Once you can do that reliably, you'll know what to look for and where to go next.

Which versions of each database are covered?

MySQL 8.0+, PostgreSQL 14+, SQL Server 2019+, and Oracle 19c+. The core concepts apply to older versions, but some commands shown (like EXPLAIN ANALYZE in MySQL) are version-specific.

Is there a refund policy?

Yes. If you go through the videos and feel it wasn't worth it, email me and I'll refund you.