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 |
What is a lds (linear data set)?
How do you fix the problem associated with VSAM out of space condition?
Can we copy Vsam files from a Vsam file in Iebgener step?
4 Answers iGate, Tech Mahindra,
What is the purpose of the FILE STATUS clause in the SELECT statement?
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 are the different versions of gdg named?
how can you load a vsam data set with records ?
what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.
What is the purpose of control intervals in vsam?
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?
can we create PS file using IDCAMS utility?
What are the types of VSAM datasets?