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

how do you create an alternate index ?

1076


Differentiate between ci split and ca split?

1020


What are the advantages of vsam over isam?

1137


What is the main purpose of having user catalog in vsam?

1068


OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output

2515


what do you mean by the cobol record key clause in vsam?

1023


explain the information contained in ci

1041


explain in brief how you can create a vsam file?

1140


what are the idcams commands that can be used for vsam and explain each of them.

999


Explain about the file objects in vsam?

1049


Explain the difference between lds and esds?

1043


What is speed parameters in define cluster command?

1042


What is the purpose of idcams?

1056


what do you mean by idcams? Explain its purpose?

967


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

969