Like an index in a book, an index in a database lets you quickly find specific information in a table or indexed view.
Hai,
Index is generally created on a table to make search&Retrieval faster.Though we're using Index on small databases,we can't understand the difference in speed.
Index doesn't provide any help to user in front end.It'll make the search process easier and saves time.Try it with a large Database.U can able to get it.