Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
Answer Posted / 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 |
Post New Answer View All Answers
What is the main function of key sequenced data set in vsam?
Explain the function of the relative record data set?
What are the different parameters that are used in vsam?
there are seven idcams commands in vsam. Can you name and explain each of them?
Explain the process in which flat files are converted into vsam files?
What is the use of access method services in vsam?
What is the purpose of relative record data set used in vsam?
How do you calculate record size of an alternate cluster?
Explain about the file objects in vsam?
What are the steps involved in access method services?
What is the biggest disadvantage of using a vsam dataset?
what is the use of the file status clause in the select statement in vsam?
explain how do you define a gdg in vsam?
what are s0c1, s0c4, s0c5, s0c7 abends?
name the utility program closely associated with vsam?