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 idcams? Explain its purpose?

539


Why is master catalog used in vsam?

575


what will happen when you try to open an empty vsam file in a cobol program for input?

621


Explain the significance of the shareoptions parameter?

532


why ci and ca splits are not possible in esds and rrds?

709






Explain the biggest disadvantage of using a vsam dataset?

580


differentiate between sequential files and esds files in vsam?

585


what is a base cluster in vsam?

663


Can you delete vsam files with the delete option of the disposition parameter of jcl?

656


what is meant by s0c-07 system abend codes?

567


explain in brief how are different versions of gdg named?

538


What is the biggest disadvantage of using a vsam dataset?

605


Using alternate indexes in batch program?

591


What is the main function of key-sequenced data set?

568


what is the probability of a complete system distortion under high end low performing multiprocessor job?

2025