Interested to Buy Any Domain ? << Click Here >> for more details...
Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
- 1 Answers
- 6027 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what will happen if there is no secondary allocation made for datasets?
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 use of lds (linear data set)?
Why is master catalog used in vsam?
what is the meaning of each of the values in shareopts(2 3)?
what is the purpose of the verify function of idcams?
what do you mean by idcams? Explain its purpose?
Differentiate between control interval (ci) and control area (ca)?
what is the syntax of ams modal commands?
Define gdg?
explain the information contained in ci
State the differences between vsam and non-vsam files?
What is the use of KSDS,LDS,ESDS,RRDS??what is VRRDS?? How are all these useful in realtime scenario??Plz helpme out...Its a recent question in IGATE..
what are the additional information you should give in the dd statement while defining the next generation of a gdg?
What are the different commands used in idcams for vsam?
