"Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message
news:P8goc.33639$TT.10721_at_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
>
>
My apologies. That should be PCTFREE not PCTUSED.
Douglas Hawthorne
Received on Tue May 11 2004 - 21:46:52 CDT
