Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
Answer Posted / scott
If you are reading more than one record it is potentially
slower using the ALT INDEX. The reason is the primary index
is clustered, so you do not perform an I/O when you get the
next record in the index.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
how do you define an altindx ? How do you use altindxs in batch, cics programs?
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..
difference between vsam and database tables
Is it slower if you access a record through alt index as compared to primary index?
explain in brief why do vsam take more disk space than other utilities?
explain the information contained in ci
Using alternate indexes in batch program?
What are the access method services used in vsam?
what do you mean by idcams? Explain its purpose?
Tell me how many alternate indexes you can have on a dataset?
What is the purpose of idcams?
what is the meaning of dynamic processing in vsam?
is it required that primary key values have to be unique? Do alternate key values have to be unique?
How do you define an altindx?
What is the purpose of relative record data set used in vsam?