Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
- 1 Answers
- 5580 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 |
On which dataset you can have alt index?
What is a path?
what is a base cluster in vsam?
Define base cluster?
differentiate between sequential files and esds files in vsam?
what is the purpose of the verify function of idcams?
What is the difference between sequential files and ESDS files?
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...
What is the significance of the SHAREOPTIONS parameter?
What is Base Cluster ?
How do you initialize a VSAM file before any operation? a VSAM with alternate index?
What is a ci split? What is a ca split?
COBOL 
