Indexing is helpful to search records in a database in an efficient manner with reduced access time.( search is performed with the help of that field-value on which an index is created/defined )
Some basic concepts related to indexing are explained below:
- Search Key : The attribute through which the records are searched.
- Record File : The file in which the complete reocrd/data is stored.