EXPLAIN - The Best And Worst Tool For Speeding Up SQL Queries

Dave Stokes

Tuesday 23 April 2024 from 11:00 to 12:00

Talk in English - US at php[tek] 2024
Short URL: https://joind.in/talk/8635d (QR-Code (opens in new window))

Avg. Rating

Structured Query Language can be tricky. The main tool that is used to check query performance is EXPLAIN. EXPLAIN is beyond tricky, having its own little quirks and foibles. This is an introductory session into its use with MySQL and PostgreSQL where you will learn to decipher what EXPLAIN is trying to tell you. EXPLAIN is a handy tool once you learn how to read the entrails.

Comments

Comments are closed.

Gina-Marie Rollock at 11:54 on 23 Apr 2024 (via Web2 LIVE)

I have many queries that I'd like to pass through this.

Sean Prunka at 12:05 on 23 Apr 2024 (via Web2 LIVE)

Dave is very knowledgeable on pretty much anything SQL. Fantastic talk. Definitely learned some new things about using EXPLAIN and ANALYZE

Greg Fox at 14:38 on 24 Apr 2024 (via Web2 LIVE)

Great talk, I just wish there was more time to dive into some more complex queries or ways some common slow queries could be rewritten.

Myles Hyson at 10:07 on 25 Apr 2024 (via Web2 LIVE)

Im gonna go back and start analyzing all our projects.

Joanna Kus at 14:07 on 25 Apr 2024 (via Web2 LIVE)

Very informative, but wish speaker spoke with more energy. Would help with keeping audience engaged.