is it slower if you access a record through alternative index as compared to primary index?
Answer Posted / guru
Yes, because the alternate key would first locate the primary key, which in turn locates the actual record.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what do you mean by define model parameter?
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...
explain the differences between vsam and non-vsam files
What is control area?
what do you mean by a shareoptions parameter (shr) in define cluster command?
Define dynamic processing?
what does a file status of 02 on a vsam signifies?
Discuss record management in vsam?
what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?
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..
how do you create an alternate index ?
explain how many ways you can load data in a vsam cluster?
what how do you initialize a vsam file before any operation? A vsam with alternate index?
What is the purpose of having vsam data space?
what is buffering and how does it apply to vsam files ?