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 is the RRN for the first record in RRDS?

what is control interval(CI) and control Area(CA)

what does a file status of 02 on a vsam signifies?

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

Explain the difference between lds and esds?

what do you mean by the repro command?

to use the rewrite command, how should the vsam file be opened?

what are s0c1, s0c4, s0c5, s0c7 abends?

what do you mean by a shareoptions parameter (shr) in define cluster command?

how do you define an altindx ? How do you use altindxs in batch, cics programs?

What is an RBA in rrds? What does it do? What is it used for?

What is the biggest disadvantage of using a vsam dataset?

For more VSAM Interview Questions Click Here