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
- 6037 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
What are the different versions of gdg named?
what will happen when you try to open an empty vsam file in a cobol program for input?
What is the main function of key sequenced data set in vsam?
how do you define an altindx ? How do you use altindxs in batch, cics programs?
what does a file status of 02 on a vsam signifies?
what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?
if you wish to use the rewrite command how must the vsam file be opened?
Explain the difference between lds and esds?
there are seven idcams commands in vsam. Can you name and explain each of them?
what is meant by dirty read in vsam?
Would you specify freespace ce for an esds?
Define gdg?
Using alternate indexes in batch program?
what is a base cluster in vsam?
Explain the significance of the shareoptions parameter?
