Interested to Buy Any Domain ? << Click Here >> for more details...
Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
- 1 Answers
- 5851 Views
- I also Faced
- E-Mail Answers
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
Explain the process in which flat files are converted into vsam files?
On which dataset you can have alt index?
how do you create an alternate index ?
What does the keyranges parameter in define cluster commends do?
why ci and ca splits are not possible in esds and rrds?
What is the use of access method services in vsam?
what is the probability of a complete system distortion under high end low performing multiprocessor job?
how can you load a vsam data set with records ?
is it required that primary key values have to be unique? Do alternate key values have to be unique?
What is the use of lds (linear data set)?
there are seven idcams commands in vsam. Can you name and explain each of them?
what do you mean by a shareoptions parameter (shr) in define cluster command?
Explain the significance of the shareoptions parameter?
what do you mean by a vsam split?
Explain the function of the relative record data set?
