An index containing every column a query needs, avoiding a read of the underlying table.
An index that contains every column referenced by a query, letting the result be returned without accessing the underlying table. Because it eliminates the need to touch the underlying table at all (which normally means random I/O), it's known as a technique that can deliver an even bigger performance gain than a regular index that merely speeds up the search itself.
© 2026 ITBGM