Indexing in mysql database

By | July 4, 2014

My database name is testdata

it has 3 fields

ID,Name,City

for increasing the speed of getting data using name field us the following method

Query is like below

Select * from testdata order by Name asc

For creating indexing for the Name field

create index Name_index on testdata (Name);

Indexing will slow down the insert and update.