Hi Tanel, I have no idea but if you currently have 9 entries in a leaf block and the 10th entry you're about insert causes this type of split, then 9 entries (the 90% currently in the existing leaf node) remain and the new entry (10%) goes into the new leaf node.
A 90-10 (%) split. Possible with small blocks (say 2K) and large index entries (200ish bytes) when 2K blocks ruled the Oracle seas. Like I said I have no real idea but it's my theory and makes a good bed-time story. Cheers ;) Richard ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 12:24 AM > Hi! > > I wonder why does statistic "leaf node 90-10 splits" imply that right-hand > index leaf block is split as 90-10, not 100-0 as it really is. (tested on > 9.2.0.4 W2k). > > Historical reasons? > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
