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


Please Help Members By Posting Answers For Below Questions

Name the sections present in data division.

897


what is s000 u4087 error? please give the all error codes in cobol,jcl.

17511


INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?

621


What is link edit in cobol?

939


There are 5 fields and 1000 records in a file. Unload it into an array. Write the syntax for declaration and how will you unload it.

1161


Explain the configuration section of a cobol program with examples of syntax.

861


How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)

2994


Explain about different table spaces.

854


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.

2234


how to access the file from prodution from changeman tool and to submit a file to production

7077


What is report-item in COBOL?

894


how do you reference the fixed unblock file formats from cobol programs

922


What is redefines clause in COBOL?

1035


How did the release of cobol/370 version 1.3 improve the performance of release 1.1?

862


Give some examples of command terminators?

944