Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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.

1442


What is amode(31)

1182


I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.

1568


Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?

1365


Why is it necessary that file needs to be opened in I-O mode for REWRITE?

1331


What is the difference between binary search and sequential search?

1097


Name some of the examples of COBOl 11?

3148


how do you reference the rrds file formats from cobol programs

1587


What are the different rules for performing sort operation?

1231


What is comp-1 and comp-2?

1234


What is redefines clause in COBOL?

1299


What is amode(24)?

1251


Explain what you understand by passing by value.

1160


How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?

1254


Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning

1102