How To Create Index in MySQL

Today in web application performance is main issue. So performance can improved through programming side or database side. In this tutorial I will describe how to improve performance of your application database side. Index is very important factor to improve performance.
When the application has too much data and updated frequent data, which is based on condition then you need to define index on table column.

Alter table `operationdatafield` ADD INDEX (`OperationId`,`FieldName`,`Period`) ;


Support US!,Subscribe Our Mailing List

Subscribe our newsletter and get awesome free article Updates and Demos.

Recommended For You
How to install Zend Optimizer on wamp

In this tutorial I will tell you how to work with Zend Optimizer (Runtime for PHP 5.2 and earlier) module...