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`) ;