What are the advantages of having an index structure?
Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the records without influencing the physical placement of records on disk. They allow efficient access to records based upon the indexing fields that are employed to construct the index. Indexes are used to enhance the efficiency of retrieval of records from a data file.