Term Kind Topic What it is
Query Optimisation practice Query Optimisation Making the database do less work — usually by removing round trips and rows rather than by rewriting clever SQL.
Write-Amplification Audit Index Cost Review, Write Path Accounting practice Query Optimisation Accounting for everything a single logical write actually costs - indexes, replication, triggers, deletion of old rows - before concluding that a database needs more capacity.