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
- 5952 Views
- I also Faced
- E-Mail Answers
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 are the different commands used in idcams for vsam?
Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
Explain about the file objects in vsam?
how yo view the vsam file?
what do you mean by define model parameter?
how many buffers are allocated to vsam ksds and esds?
How to declare the EMP Name, EMP No., DOB in VSAM KSDS file? Please explain.....
what is the use of aix in vsam why do we go for aix and wht is build index in vsam?
what's the biggest disadvantage of using a VSAM dataset?
8 Answers Anjana, CTS, DSRC, IBM,
What are the distinctive features of a ksda, key sequenced dataset?
By seeing a program how we findout it is a VSAM program?
how to view clusters that has more than 10000 records
COBOL 
