Virtual storage access method (VSAM) Question: Download Questions PDF
Is it slower if you access a record through ALT INDEX as compared to Primary INDEX?
Answer:
Yes. Why? Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
Download VSAM Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How many ALternate Indexes you can have on a dataset? | What is RECOVERY and SPEED parameters in DEFINE CLUSTER command? |