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
- 5956 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
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.
What is the place for VSAM KSDS?
what is the meaning of each of the values in shareopts(2 3)?
What is the device independent method to indicate where a record is stored?
what will happen if there is no secondary allocation made for datasets?
how can you copy to a vsam cluster?
What is the main purpose of having user catalog in vsam?
Would you specify freespace ce for an esds?
explain how many ways you can load data in a vsam cluster?
How is the sorting of vsam files carried?
What are the information stored in ci?
Define base cluster?
is delete operation supported in an esds? Is rewrite operation possible in esds?
what is meant by dirty read in vsam?
explain in brief why do vsam take more disk space than other utilities?
