Re: leaf node 90-10 splits

2003-12-10 Thread Richard Foote
: 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

Re: leaf node 90-10 splits

2003-12-10 Thread Yong Huang
Hi, Tanel, Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2 documentation. If the index is on strictly monotonically increasing numbers, won't a new node be added to the right without a block split? Yong Huang I wonder why does statistic leaf node 90-10 splits

Re: leaf node 90-10 splits

2003-12-10 Thread Jared . Still
On 9i: select * from v$statname where name like '%leaf%'; Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/10/2003 07:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: leaf node 90-10 splits

Re: leaf node 90-10 splits

2003-12-10 Thread Tanel Poder
Hi! SQL select * From v$sysstat where name like '%split%'; STATISTIC# NAME CLASS VALUE -- -- -- 195 leaf node splits 128612 196 leaf node 90-10 splits 128209 197

Re: leaf node 90-10 splits

2003-12-10 Thread Jonathan Lewis
! SQL select * From v$sysstat where name like '%split%'; STATISTIC# NAME CLASS VALUE -- --- - -- -- 195 leaf node splits 128612 196 leaf node 90-10 splits 128209 197

leaf node 90-10 splits

2003-12-09 Thread Tanel Poder
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