: 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
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
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
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
!
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
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