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

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

730


differentiate between sequential files and esds files in vsam?

587


What are the steps involved in access method services?

543


what is meant by s0c-07 system abend codes?

569


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

559






Would you specify freespace ce for an esds?

603


Explain the function of the relative record data set?

543


what do you mean by the repro command?

571


What is the biggest disadvantage of using a vsam dataset?

609


difference between vsam and database tables

643


What is a ci split? What is a ca split?

655


what is the use of the file status clause in the select statement in vsam?

570


What is the function of entry sequenced data set?

650


What is the device independent method to indicate where a record is stored?

587


Differentiate between control interval (ci) and control area (ca)?

536