is it slower if you access a record through alternative index as compared to pri

is it slower if you access a record through alternative index as compared to primary index?

Question Posted / senjons_murmu

1 Answers
2741 Views
IBM, I also Faced
E-Mail Answers

is it slower if you access a record through alternative index as compared to primary index?..

Answer / 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

More VSAM Interview Questions

what is freespace

2 Answers EDS,

How to rename one vsam file as well as it's index?

4 Answers BEA,

What are the advantages of vsam over isam?

0 Answers

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

0 Answers IBM,

Using Alternate Indexes in CICS pgms: ?

1 Answers

Can we copy a sequential file to a VSAM file ? If yes, What will happen of the size of the sequential file is bigger than that of the VSAM file?

3 Answers CTS, Verizon,

if not using the 'commit' when closing VSAM file,what will happend

5 Answers CSC,

Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now?

2 Answers IBM,

Tell me how many alternate indexes you can have on a dataset?

0 Answers

How many cluster index can have in a table?

3 Answers HSBC,

how yo view the vsam file?

5 Answers DSRC, TCS,

What is a sequence set?

1 Answers

For more VSAM Interview Questions Click Here