TOPIC / TAG
Notes in sql
2 articles
Use EXPLAIN ANALYZE Without Surprises
Read a real PostgreSQL query plan while limiting runtime risk and remembering that ANALYZE executes the statement.
One Slow MySQL Query and the Index It Wanted
Read MySQL 8 EXPLAIN output for one slow query, choose composite index column order, make the index covering, and retire unused indexes safely by making them invisible first.