VSAM Interview Question:

Is it slower if you access a record through ALT INDEX as compared to Primary INDEX?

Submitted by: Administrator

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.
Submitted by: Administrator