Alternate Index and its' Performance



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

Alternate Index and its' Performance

Postby vmahaja1 » Tue Dec 23, 2008 3:48 pm

Hi,

Do use of alternet index cause performance degradation? Does it increase the count of EXCP's?
Thanks in advance.
vmahaja1
 
Posts: 3
Joined: Wed Dec 17, 2008 10:10 am
Has thanked: 0 time
Been thanked: 0 time

Re: Alternate Index and its' Performance

Postby dick scherrer » Wed Dec 24, 2008 12:18 am

Hello,

Creation and usage of alternate index entries usually invloves some trade-off.

There is additional overhead on adds and deletes, but usually a significant reduction in overhead when reading. A very simple example would be the case where there was a file with 5,000,000 records and 9 of them have a particular value for (let's say) PART_NO. With an alternate index, the 9 records could be found directly. With no alternate index, 5,000,000 records would need to be read. If there were many processes/inquiries that needed to read records for some specific part_no, the alternate index might be critical for these inquires to be able to run.

Each alternate index will take some amount of processing overhead as well as a bit of dasd storage. You would need to weigh the pros and cons for each particular situation. When possible, it is helpful to prototype with "real" volumes to help with the decision.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post