Question

What is multiples key access

Answer 1

Answer:

Multiple Key Accesses. To handle above situation, multiple key accesses are introduced. Here, we use combination of two or more columns which are frequently queried to get index. In the above example, both DEPT_ID and SALARY are clubbed into one index and are stored in the files.