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

is it required that primary key values have to be unique? Do alternate key values have to be unique?

0 Answers   IBM,


How did you refresh a VSAM file and how frequently you do it ?

3 Answers   CSC, IBM, Patni, Xansa,


Is it slower if you access a record through alt index as compared to primary index?

0 Answers  


what how do you initialize a vsam file before any operation? A vsam with alternate index?

0 Answers   IBM,


what is the concept of IMPORT in vsam??

2 Answers  






In a file(PS), we dont know how many records are there. requirement is divide half n half the records n insert into 2 another files(PS).

6 Answers   Cap Gemini, TCS,


differentiate between sequential files and esds files in vsam?

0 Answers   IBM,


Can we copy a sequential file to a VSAM file ? If yes, What will happen of the size of the sequential file is bigger than that of the VSAM file?

3 Answers   CTS, Verizon,


How to delete a member using JCL.?

5 Answers  


How do you convert flat files to VSAM files ?

5 Answers   EDS, IBM,


What are the common vsam error conditions and codes?

0 Answers  


When CISZ is declared as 4096 at cluster level,is this true that data will have 4096 and index will have default?????

1 Answers   Wipro,


Categories