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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the main function of key sequenced data set in vsam?

921


Explain the function of the relative record data set?

898


What are the different parameters that are used in vsam?

1109


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

1071


Explain the process in which flat files are converted into vsam files?

963


What is the use of access method services in vsam?

1001


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

1050


How do you calculate record size of an alternate cluster?

1076


Explain about the file objects in vsam?

1002


What are the steps involved in access method services?

912


What is the biggest disadvantage of using a vsam dataset?

1086


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

1068


explain how do you define a gdg in vsam?

969


what are s0c1, s0c4, s0c5, s0c7 abends?

1250


name the utility program closely associated with vsam?

991