Tag Archives: indexing for a particular field

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 »