Yes. Because the alternate key would first locate the
primary key, which in turn locates the actual record. Needs
twice the number of I/Os.
Answer / Garima Agrawal
"Correct answer: Yes. The reason is that an alternate key needs to first search for and locate the primary key before it can find the actual record. This results in double the number of I/Os compared to direct access using the primary key."
| Is This Answer Correct ? | 0 Yes | 0 No |
How many times secondary space allocated?
What are the advantages of vsam over isam?
Using alternate indexes in batch program?
If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
What is File Status in VSAM?
Can you delete vsam files with the delete option of the disposition parameter of jcl?
How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgm?s ?
Common VSAM Error conditions and codes
Why is master catalog used in vsam?
What is the Difference between LDS & ESDS ?
Explain the function of entry-sequenced data set?