Tag: database
Query Optimisation
1
The process of rewriting SQL queries and database structures to reduce execution time — using EXPLAIN to identify full table scans, adding targeted indexes, rewriting JOINs, and eliminating N+1 patterns.
2mo ago
database intermediate
Query Optimisation
PHP 5.0+ Analysing and rewriting database queries to reduce execution time, I/O, and resource usage.
3mo ago
performance intermediate
Query Plan & EXPLAIN Analysis
The execution strategy the database engine chooses for a query — analysed with EXPLAIN to identify full scans, missing indexes, and bottlenecks.
3mo ago
performance intermediate