How To Create Index in MySQL Example

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

How To Add Index In Mysql Table

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