Performance

Query Tuning

English

Overview

The work of improving how efficiently SQL executes.

Details

The work of improving query performance by analyzing the execution plan and reviewing index design. The first step is typically checking the execution plan with something like EXPLAIN to see whether an unexpected full scan or inefficient join order is occurring.

More Database terms