Re: separate data/inidex

Daniel A. Morgan wrote:
>
> Great ... we are 70% of the way there. Lets see if we can but the top on the box
> and tie a ribbon around it.
>
> I am looking at at Kevin Loney and Marlene Theriault's book Oracle 8i DBA
> Handbook, page 97, section title I/O Contention Among Datafiles. And the next

[snip]

Here is quote from a Loney book (can't remember the title offhand)

"...you should specify a very low value for pctfree ...the space used by deleted entries within an index is not reused..."

which pretty much sums up the amount of credence I place on that book

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."