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...


Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?



Is it slower if you access a record through ALT INDEX as compared to Primary INDEX? Why?..

Answer / scott

If you are reading more than one record it is potentially
slower using the ALT INDEX. The reason is the primary index
is clustered, so you do not perform an I/O when you get the
next record in the index.

Is This Answer Correct ?    9 Yes 0 No

Post New Answer

More VSAM Interview Questions

How many buffers are allotted to VSAM KSDS and ESDS?

1 Answers  


can i see how many records does a vsam file have without browsing or without using file-aid? and same for ps file?

3 Answers   Tech Mahindra,


In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

0 Answers   RBS,


What is Base Cluster ?

1 Answers  


can you specify some the distinctive features of a ksds, key sequenced dataset?

0 Answers   IBM,


how many ways can we open i vsam file ? like print ch ids (/) is thre any other way to open the vsam file please can any one answer ?

2 Answers  


Explain the difference between lds and esds?

0 Answers  


why ci and ca splits are not possible in esds and rrds?

0 Answers   IBM,


HOW TO SORT RECORDS IN VSAM FILE?

3 Answers  


What is a CA, control area?

1 Answers  


can alternate index use in ESDS since it does not contain primary index? if yes can you explain?

3 Answers   Temenos,


when u r using repro command what happens if both infile and outfile names same

4 Answers  


Categories