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 |
should a AIX should be a unique value?
can you specify some the distinctive features of a ksds, key sequenced dataset?
Assuming that the DEFINE JCL is not available, how do you get info about a VSAM file's organisation?
Do all versions of the GDG have to be of the same record length ?
What are the advantages of vsam over isam?
What is a vsam dataset?
Explain the purpose of the file status clause in the select statement?
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 ?
can we create PS file using IDCAMS utility?
How did you refresh a VSAM file and how frequently you do it ?
3 Answers CSC, IBM, Patni, Xansa,
In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?
what is reuse parameter ?