What is Alternate Index ? How is it different from regular
index ?

Answers were Sorted based on User's Feedback



What is Alternate Index ? How is it different from regular index ?..

Answer / vish

The answer provided by NK is absolutely correct but we
should be very careful whil choosing the alternate index as
it may not be Unique. e.g. in the example given by NK, the
Emp# will always be Unique within a company but many many
employees can have the same name. So if we declare Emp_name
as AIX (i.e. alternate Index) and then use it for fetching
data then we may end up in multiple rows and hence we may
need additonal logic to arrive at the desired unique record.

Your comments are Welcome!!

Is This Answer Correct ?    14 Yes 0 No

What is Alternate Index ? How is it different from regular index ?..

Answer / 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

More COBOL Interview Questions

if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need

0 Answers  


When search all is used in cobol program without sorted input data?

6 Answers   CGI, Principal Finance,


DATAONLY, MAPONLY functionality?

1 Answers   IBM,


I have the requirement to compare the two files and pick up the matching records. File 1. file2 23 32 32 13 34 15 35 36 36 35 43 Get the matching records from this 2 files to out file. how you will do this in cobol program?

15 Answers   ADP, Broadridge, CTS, HSBC, L&T, RBS, TCS,


i want to store 20 digits . h will u do it in cobol ?

4 Answers   TCS,


hi, can you ppl tell me, how to check whether the rewrite we gave for the ksds file is successful or not in the program.? i gave rewrite, the rewrite code is executing and maxcc=0 but updation doenot happen in the file?

1 Answers   CGI,


I have files that contains both duplicates files(occur more than twice) and non-duplicate files.The file is already sorted by a key.I want to determine those records that are duplicate and will be move to a duplicate file and non- duplicate files to be move to a valid file.thank you.help please

2 Answers  


Why we should use cursor ?

3 Answers  


what is filler and what is use of filler

3 Answers   Syntel,


What is normalisation?

2 Answers   IBM,


Describe the difference between subscripting and indexing ?

2 Answers  


1.give the details about WHEN OTHER. 2. how many form are available in evaluate.

0 Answers   IBM,


Categories