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.