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
Define free space?
is it required that primary key values have to be unique? Do alternate key values have to be unique?
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
How do you calculate record size of an alternate cluster?
Discuss record management in vsam?
What are the steps involved in access method services?
what do you mean by a shareoptions parameter (shr) in define cluster command?
What is recovery parameters in define cluster command?
On which dataset you can have alt index?
State the differences between vsam and non-vsam files?
Using alternate indexes in cics program?
what do you mean by the cobol record key clause in vsam?
what do you mean by the repro command?
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
Explain the index set?