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



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

Post New Answer

More VSAM Interview Questions

What does the KEYRANGES parameter in Define Cluster commend do?

1 Answers  


What is the procedure for running the batch job in mainframe?

1 Answers  


Why is it required to have a keyed directed retrieval?

0 Answers  


what do you mean by idcams? Explain its purpose?

0 Answers   IBM,


what is meant by s0c-07 system abend codes?

0 Answers   IBM,






I have three fields in a Variable VSAM file X(2) Y(10) occurs X times Z(02) Say for the first record X=2 then the length of the file is 2+(10*3)+2=34 second record, x=4 then 4+(10*4)+2=46 If any time if the field x is updated then the total length changes. Is it feasible? Is it

2 Answers  


explain in brief how you can create a vsam file?

0 Answers   IBM,


What is a lds (linear data set)?

0 Answers  


What is the device independent method to indicate where a record is stored?

0 Answers  


why do we use vsam file thn seqential files ?

3 Answers   Tech Mahindra,


explain in brief why do vsam take more disk space than other utilities?

0 Answers   IBM,


What is the index set?

1 Answers  


Categories