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 is the COBOL RECORD KEY clause?
what is buffering and how does it apply to vsam files ?
what is the use of the file status clause in the select statement in vsam?
On which dataset you can have alt index?
what is the RRN for the first record in RRDS?
What is the upgrade set?
What is the index set?
what do you mean by a vsam split?
What are the information stored in ci?
What is the purpose of having vsam data space?
Can you delete vsam files with the delete option of the disposition parameter of jcl?
how yo view the vsam file?