Tag Archives: tuning in mysql tag:indexing on mysql database

Indexing in mysql database

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… Read More »