RE: best index performance

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:
> dr2@cssas400.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: dr2@cssas400.com
+---