What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 13870 Views
- I also Faced
- E-Mail Answers
Answer Posted / nk
The purpose of any index is to provide the most efficient
access to the records in a file. Say you have a file of
employee names and numbers. Usually the primary index will
be the employee number. If you request a record by
providing the empl#, the access will be very fast. If you
have to very often request a record by the empl name, you
may want to create a second (a/k/a alternate) index based
on the name. So when you provide a name, the access to the
correct record also will be very fast.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
What are the different rules to perform a Search?
What are the pertinent COBOL
Give some examples of command terminators?
write a cobol logic. i have file that has 10 records .1 record go to first output file and second record goes to 2 output and etc
Why is it necessary that file needs to be opened in I-O mode for REWRITE?
What is the difference between goback, stop run and exit program in cobol?
) How do u handle errors in BMS macro?
How do you define a variable of comp-1 and comp-2?
how do you reference the ksds vsam file formats from cobol programs
Define cobol?
Whats the difference between search & search ALL?
How can you get the ksds file records into your cobol program?
