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

Define free space?

995


is it required that primary key values have to be unique? Do alternate key values have to be unique?

1003


we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.

1253


How do you calculate record size of an alternate cluster?

1066


Discuss record management in vsam?

910


What are the steps involved in access method services?

904


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

1187


What is recovery parameters in define cluster command?

996


On which dataset you can have alt index?

867


State the differences between vsam and non-vsam files?

984


Using alternate indexes in cics program?

972


what do you mean by the cobol record key clause in vsam?

970


what do you mean by the repro command?

1024


OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output

2458


Explain the index set?

1050