Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what do you mean by define model parameter?

1107


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...

2711


explain the differences between vsam and non-vsam files

1116


What is control area?

1046


what do you mean by a shareoptions parameter (shr) in define cluster command?

1232


Define dynamic processing?

971


what does a file status of 02 on a vsam signifies?

1140


Discuss record management in vsam?

935


what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?

973


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..

8719


how do you create an alternate index ?

1040


explain how many ways you can load data in a vsam cluster?

1001


what how do you initialize a vsam file before any operation? A vsam with alternate index?

979


What is the purpose of having vsam data space?

927


what is buffering and how does it apply to vsam files ?

1143