Gene, doesn't that depend on how you want to use the index? I have had VERY good performance with the following settings: CPYBLA CRT-OBJECT-TYPE , X'0E0A'; /* USRIDX */ CPYBLA CRT-CREATION-OPTS, X'A0040000'; /* PERM */ CPYBLA CRT-RECOVERY-OPTS, X'00000000'; /* DFLT */ CPYNV CRT-SIZE-OF-SPACE, 4096; /* EXTENDS AS NEEDED */ CPYBLA CRT-INITIAL-VALUE, X'00'; CPYBLA CRT-PERFORMANCE , X'00000000'; CPYNV CRT-EXT-OFFSET , 0; CPYBWP .CRT-CONTEXT , .CONTEXT; CPYBWP .CRT-ACCESS-GROUP , .NULL; CPYBLA CRT-INDEX-ATTR , X'20'; /* INSERT BY KEY */ CPYNV CRT-ARGM-LENGTH , 16; /* 10 KEY, 6 DATA */ CPYNV CRT-KEY-LENGTH , 10; CRTINX .INDEX, .CREATE; > -----Original Message----- > From: Gene_Gaunt/ReviewWorks@reviewworks.com > [SMTP:Gene_Gaunt/ReviewWorks@reviewworks.com] > Sent: Tuesday, January 04, 2000 3:05 PM > To: MI400@midrange.com > Subject: best index performance > > What value combinations of the following CRTINX attributes will make > INSINXEN run the fastest when the occurence count is 4095? > > o Update: immediate / no immediate > o Insertion: by key / not by key > o Optimized for: random / sequential > > > +--- > | This is the MI Programmers Mailing List! > | To submit a new message, send your mail to MI400@midrange.com. > | To subscribe to this list send email to MI400-SUB@midrange.com. > | To unsubscribe from this list send email to MI400-UNSUB@midrange.com. > | Questions should be directed to the list owner/operator: > email@example.com > +--- +--- | This is the MI Programmers Mailing List! | To submit a new message, send your mail to MI400@midrange.com. | To subscribe to this list send email to MI400-SUB@midrange.com. | To unsubscribe from this list send email to MI400-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.