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 do you mean by a vsam split?

0 Answers   IBM,


Discuss record management in vsam?

0 Answers  


what how do you initialize a vsam file before any operation? A vsam with alternate index?

0 Answers   IBM,


What does the keyranges parameter in define cluster command do?

0 Answers  


What are the information stored in ci?

0 Answers  


what do you mean by recovery and speed parameters in define cluster command?

0 Answers   IBM,


Explain the purpose of the file status clause in the select statement?

0 Answers  


what is the difference between vsam and dataset how do u create vsam dataset which file you r used?

2 Answers   Fidelity,


What is a base cluste?

0 Answers  


What is the difference between PS file and VSAM file?

7 Answers   IBM, Infosys, Verizon,


Is it slower if you access a record through alt index as compared to primary index?

0 Answers  


Explain the meaning and syntax for the START command. ?

4 Answers   IBM,


Categories