Re: Re-use of Leaf Nodes (was: Index Management)

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Wed, 12 May 2004 02:40:47 GMT
Message-ID: <P8goc.33639$TT.10721@news-server.bigpond.net.au>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40a167db$0$25007$afc38c87_at_news.optusnet.com.au... SNIP.
> Just thought I'd mention it, anyway. Hopefully, others might repeat the
> test (or something like it) and submit their results for the 3 inserts-1
> delete-3 inserts test run.
>
> Regards
> HJR
Howard,

My results for 10.1.0.2 on WinXP Pro SP1 using a database block size of 8K are:
ID Test Done Min Inv# Max Inv# Leaf Blks B Level CF # Rows --- --------------- -------- -------- --------- ------- ------- -------

  1 Insert 10,000          1   10,000        18       1      47  10,000
  2 Insert 10,000          1   20,000        37       1      95  20,000
  3 Insert 10,000          1   30,000        56       1     143  30,000
  4 Delete 10,000     10,001   30,000        39       1      97  20,000
  5 Insert 10,000     10,001   40,000        57       1     146  30,000
  6 Insert 10,000     10,001   50,000        76       1     194  40,000
  7 Insert 10,000     10,001   60,000        95       1     242  50,000

I put PCTUSED 0 on my index definition.

Douglas Hawthorne Received on Tue May 11 2004 - 21:40:47 CDT