How To: Create database indexes in PHP/MySQL ?

Author: Zeeshan Rasool  |  Last updated on MySQL, PHP Tutorials

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.

Recommended WordPress Themes Store

If you enjoyed this post, please consider leaving a comment below or subscribing to the RSS feed to have future articles delivered to your feed reader. You can also follow us on Facebook or Twitter @99Points

This awesome post has been created by 99Points editor's team. You can follow our updates on Twitter and facebook, OR drop an email at

Comments are closed.

Email Subscriber!

Be the first to know about new updates



Popular post