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

OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output

0 Answers  


What is File Status in VSAM?

1 Answers   IBM,


how do you create an alternate index ?

0 Answers   IBM,


explain in brief how you can create a vsam file?

0 Answers   IBM,


what are s0c1, s0c4, s0c5, s0c7 abends?

0 Answers   IBM,






if not using the 'commit' when closing VSAM file,what will happend

5 Answers   CSC,


What is a lds (linear data set)?

0 Answers  


What is an alternate index and path ?

2 Answers   Infosys, TCS,


In vsam why we use export-import utility?

3 Answers  


Explain the index set?

0 Answers  


Is a delete operation possible in an ESDS?B. Is rewrite operation possible in ESDS ?

3 Answers  


How many buffers are allotted to VSAM KSDS and ESDS?

1 Answers  


Categories