How To: Create database indexes in PHP/MySQL ?

Any RDBMS like MySql are geared to perform read operations better than write operations. The efficiency in read operations are achieved by database indexes.

Indexes are most important in optimizing databases. If an application has large database then it is always optimized and indexes are part of this section.

Indices can have a significant impact on the ability of your applications to manipulate data in a very efficient way in a positive and negative sense.


Now to create index,

Indices can usually be created on one or more columns of a table and it is important to determine a good number of columns that are heavily used and to index them.

Comments are closed.