How To: Create database indexes in PHP/MySQL ?

Author: Zeeshan Rasool  |  Apr 13, 2010 MySQL, PHP

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 Stores

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

Email Subscriber!

Be the first to know about new updates

Author of 99Points
Zeeshan Rasool is an experienced PHP Web Developer and founder at 99Points. Expert in Codeigniter (MVC), WordPress, JSON, jQuery & HTML5
 LinkedIn Profile




Popular post