purpose of an index in a database

[TechBoyJK]

what is the purpose of an index in a database?

 

[xtknight]

I'm no database expert, but typically indices, when referring to software, allow for quick seeking of the file.

 

[EagleKeeper]

The index field is usally kept softed for easier retrieval of the associated data.
Saves from having to read through everything for a specific record.