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

What is the COBOL RECORD KEY clause?

2 Answers  


what is buffering and how does it apply to vsam files ?

0 Answers   IBM,


what is the use of the file status clause in the select statement in vsam?

0 Answers   IBM,


On which dataset you can have alt index?

0 Answers  


what is the RRN for the first record in RRDS?

2 Answers  


What is the upgrade set?

1 Answers  


What is the index set?

1 Answers  


what do you mean by a vsam split?

0 Answers   IBM,


What are the information stored in ci?

0 Answers  


What is the purpose of having vsam data space?

0 Answers  


Can you delete vsam files with the delete option of the disposition parameter of jcl?

0 Answers   IBM,


how yo view the vsam file?

5 Answers   DSRC, TCS,


Categories