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 |
How many buffers are allotted to VSAM KSDS and ESDS?
can i see how many records does a vsam file have without browsing or without using file-aid? and same for ps file?
In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?
What is Base Cluster ?
can you specify some the distinctive features of a ksds, key sequenced dataset?
how many ways can we open i vsam file ? like print ch ids (/) is thre any other way to open the vsam file please can any one answer ?
Explain the difference between lds and esds?
why ci and ca splits are not possible in esds and rrds?
HOW TO SORT RECORDS IN VSAM FILE?
What is a CA, control area?
can alternate index use in ESDS since it does not contain primary index? if yes can you explain?
when u r using repro command what happens if both infile and outfile names same