Query Optimization

Natural & Formal Sciences Dictionary
The process inside a database management system of selecting an execution plan for a declarative query by transforming equivalent algebraic expressions, estimating costs, and choosing operators, join orders, and access paths that minimize expected resource usage or latency.