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 |
is delete operation supported in an esds? Is rewrite operation possible in esds?
explain how many ways you can load data in a vsam cluster?
Would you specify FREESPACE for an ESDS?
What are the distinctive features of a ksds, key sequenced dataset?
How does control intervals and control areas related to each other?
there are seven idcams commands in vsam. Can you name and explain each of them?
looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?
how many buffers are allocated to vsam ksds and esds?
how to view clusters that has more than 10000 records
Under idcams, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system?
Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now ?
What is the purpose of relative record data set used in vsam?