Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
- 1 Answers
- 5006 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 is a ca split?
What is the main function of linear dataset?
name a few common vsam status codes?
What is a base cluste?
How many times secondary space allocated?
1. delete is not possible in esds. why? 2. i have 10 records in a esds file and i want to delete only 1st record ..then what i have to do?.. it will not affect any sequence of the RBA. 3. why open extend is not possible in rrds vsam file?
On which dataset you can have alt index?
How can you create a VSAM dataset? Can you write a JCL for it?
What is a vsam dataset?
what is the RRN for the first record in RRDS?
Do primary key values have to be unique? Do alternate key values have to be unique?
what do you mean by a vsam slot?
COBOL 
