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.

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

addindex

The following two tabs change content below.
Hi, This is Parvez Alam from India. I am software developer with 4 years’ experience in web development. I have submitted articles on PHP, Mysql, Magento,CSS, HTML, jQuery, web designing and social API. You can subscribe to my blog via RSS/Twitter/Google plus and Facebook. parvez1487(at)gmail(dot)com

Latest posts by Parvez (see all)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>