Query Plan - CI/CD Glossary Definition
A query plan is the execution strategy the database optimizer picks for a query: the order of joins, which indexes to use, and whether to scan or seek. EXPLAIN reveals it.
Related guides
Index Scan - CI/CD Glossary DefinitionAn index scan reads rows by walking a database index instead of the whole table, jumping straight to matching…
Full Table Scan - CI/CD Glossary DefinitionA full table scan reads every row in a table to satisfy a query. Fine for small tables, but a common bottlene…
Prepared Statement - CI/CD Glossary DefinitionA prepared statement is a pre-parsed SQL template with bound parameters, reused across executions - it speeds…