Re: Number of extents too high

Chloe Crowder wrote:

> Hi
>
> is there a point at which the number of extents for a table/index in a
> locally managed tablespace becomes too high? I've seen a number of
> postings in the group which say not to worry, 40 or 50 isn't a
> problem, but we have a number of tables which have hundreds of
> extents, and at least three with over a thousand (the highest being an
> index with over 22,000, which seems a bit excessive!).
>
> Chloe Crowder

Too high for what? Most of what is written about problems based on a large number of extents is either very old or pure mythology.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)