EXPLAIN Plan
EXPLAIN SELECT..., detailed, information, deta hai — type, column, DIKHТА, hai, ki, KIS, tarah, ki, ACCESS, ki, gayi, (ALL = full, table, scan, ref/range = index, use, hua). rows, column, ESTIMATE, deta, hai, ki, KITNI, rows, EXAMINE, hongi.
possible_keys, column, dikhaता hai, KAUN, se, indexes, MySQL, consider, kar, sakta, tha. key, column, dikhaता, hai, KAUN, sa, index, ACTUALLY, USE, hua.
EXPLAIN SELECT * FROM orders WHERE status = 'completed';
-- Output mein check karo:
-- type: ALL (bad, full table scan) vs ref/range (good, index used)
-- rows: kitni rows examine hongi (jitna kam, utna behtar)
-- key: kaun sa index actually use hua- EXPLAIN = query, execution, ki, detailed, information
- type: ALL (bad, full scan), ref/range (good, index, used)
- rows, aur, key, columns, se, query, efficiency, samajhi, ja, sakti, hai
EXPLAIN ANALYZE, (MySQL 8.0.18+) QUERY, ko, ACTUALLY, RUN, karके, REAL, execution, statistics, deta hai — regular, EXPLAIN, sirf, ESTIMATED, plan, deta hai, ANALYZE, ACTUAL, TIMING, aur, ROW, counts, deta hai.
EXPLAIN ANALYZE SELECT * FROM orders WHERE status = 'completed';Extra, column, mein, "Using filesort" YA, "Using temporary" dikhna, EK, RED, FLAG, ho, sakta hai — ISKA, MATLAB, hai, ki, MySQL, ko, EXTRA, sorting/temporary, TABLE, work, karna, PADТA hai, JO, SLOW, hai.