ecember 10, 2003 9:24 PM
> Hi!
>
> SQL> select * From v$sysstat where name like '%split%';
>
> STATISTIC# NAME
> CLASS VALUE
> -- ---
-
> -- ------
> 195 leaf
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
1282
Subject: Re: leaf node 90-10 splits
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 sp
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 "
t; <[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 reason
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 Po