is it slower if you access a record through alternative index as compared to pri

is it slower if you access a record through alternative index as compared to primary index?

Question Posted / senjons_murmu

is it slower if you access a record through alternative index as compared to primary index?..

Answer / guru

Yes, because the alternate key would first locate the primary key, which in turn locates the actual record.

Is This Answer Correct ?

0 Yes

0 No

More VSAM Interview Questions

what are s0c1, s0c4, s0c5, s0c7 abends?

can we create PS file using IDCAMS utility?

Describe the uses of ams?

explain how can you initialize a vsam file before any operation?

What is the meaning of the DEFINE MODEL parameter?

Explain about the file objects in vsam?

During processing of a VSAM file, some system error occurs and it is subsequently unusable . What do you do ?

What is the index set?

name a few common vsam status codes?

What is a VSAM slot?

What happens when you open an empty VSAM file in a COBOL program for input?

HOW TO SORT RECORDS IN VSAM FILE?

For more VSAM Interview Questions Click Here