Index
An index is a data structure that speeds up database queries by keeping sorted references to table rows. Without an index the database scans the whole table. Indexes speed up SELECT but slightly slow down INSERT/UPDATE and consume storage.
An index is a data structure that speeds up database queries by keeping sorted references to table rows. Without an index the database scans the whole table. Indexes speed up SELECT but slightly slow down INSERT/UPDATE and consume storage.