What is Alternate Index ? How is it different from regular
index ?
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
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
How you can read the file from bottom?
What is the compute verb? How is it used?
Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.
What are the different rules of SORT operation?
How you can characterize tables in cobol?
i have 10 names in an array and my name is one of them also array is not in sorted order i need to display my name using index how will i do this
INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?
What is the problem of ordered sequential files access?
) how do u code after getting data?
What is the difference between comp and comp-3 usage?
What is the Purpose of POINTER Phrase in STRING command in COBOL?
What are all the divisions of a COBOL program?
What is report-item in COBOL?
How do you differentiate between cobol and cobol-ii?