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 a lds (linear data set)?

0 Answers  


How do you fix the problem associated with VSAM out of space condition?

1 Answers   IBM,


Can we copy Vsam files from a Vsam file in Iebgener step?

4 Answers   iGate, Tech Mahindra,


What is the purpose of the FILE STATUS clause in the SELECT statement?

1 Answers  


Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now?

3 Answers  


What are the different versions of gdg named?

0 Answers  


how can you load a vsam data set with records ?

0 Answers   IBM,


what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.

4 Answers   Target,


What is the purpose of control intervals in vsam?

0 Answers  


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,


can we create PS file using IDCAMS utility?

3 Answers   IBM,


What are the types of VSAM datasets?

3 Answers   IBM,


Categories