php[tek] 2024 php[tek] 2024 Login
EXPLAIN - The Best And Worst Tool For Speeding Up SQL Queries
Speaker: Dave Stokes
EXPLAIN - The Best And Worst Tool For Speeding Up SQL Queries

Level: Beginner
Length: Standard (50 minutes)

Description:
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.

Thanks to our php[tek] 2025 sponsors!
PHP Architect
(Platinum)