Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
Answer / scott
If you are reading more than one record it is potentially
slower using the ALT INDEX. The reason is the primary index
is clustered, so you do not perform an I/O when you get the
next record in the index.
| Is This Answer Correct ? | 9 Yes | 0 No |
what do you mean by a vsam split?
Discuss record management in vsam?
what how do you initialize a vsam file before any operation? A vsam with alternate index?
What does the keyranges parameter in define cluster command do?
What are the information stored in ci?
what do you mean by recovery and speed parameters in define cluster command?
Explain the purpose of the file status clause in the select statement?
what is the difference between vsam and dataset how do u create vsam dataset which file you r used?
What is a base cluste?
What is the difference between PS file and VSAM file?
7 Answers IBM, Infosys, Verizon,
Is it slower if you access a record through alt index as compared to primary index?
Explain the meaning and syntax for the START command. ?