SQL, Chapter 12: Indexes and CREATE INDEX
Indexes speed up searches for data. While they are very effective at doing this, they also represent an extra operation when inserting, updating and deleting data, since every table update also requires an update of the index. Sequential Access To … Continued