In an indexed file system, you notice that certain records are accessed frequently, while others are rarely accessed. How can you optimize the performance of record retrieval for frequently accessed records?

  • Clustering frequently accessed records together
  • Implementing a multi-level index
  • Increasing the size of the index file
  • Using alternate indexes
Clustering involves physically arranging records in the file so that frequently accessed records are stored close together. This reduces the number of disk accesses required to retrieve these records, thereby improving performance for frequently accessed data.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *