Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
EXPLAIN SELECT * FROM orders WHERE customer_id = 42 AND status = 'shipped'; -- Key columns to check: -- type: ref/range is good; ALL is a full table scan (bad) -- key: which index is used -- rows: estimated rows examined
Result
Open