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

is delete operation supported in an esds? Is rewrite operation possible in esds?

0 Answers   IBM,


explain how many ways you can load data in a vsam cluster?

0 Answers   IBM,


Would you specify FREESPACE for an ESDS?

1 Answers  


What are the distinctive features of a ksds, key sequenced dataset?

2 Answers  


How does control intervals and control areas related to each other?

0 Answers  


there are seven idcams commands in vsam. Can you name and explain each of them?

0 Answers   IBM,


looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?

2 Answers   IBM, Infosys,


how many buffers are allocated to vsam ksds and esds?

0 Answers   IBM,


how to view clusters that has more than 10000 records

2 Answers  


Under idcams, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system?

0 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 ?

4 Answers   Patni,


What is the purpose of relative record data set used in vsam?

0 Answers  


Categories