Query
Data & DatabasesA question asked of the database.
A request for data. Cheap when an index supports it, ruinous when it forces a scan of every row. Which questions you ask should be a design decision, not an accident.
See also Index, N+1, Full table scan