Mega Code Archive

 

Categories / MySQL Tutorial / Table

 

Using Indexes

An index is a structured file that facilitates data access. Indexes speed up data access for SELECT queries, but they slow it down for INSERT, UPDATE, and DELETE queries. Indexes also work better on columns that contain unique data. One index can be made up of one or more columns. You can also have more than one index in a table.