Re: Database reorg in Oracle 8?

"Sheilah Scheurich" <mommydba_at_hotmail.com> wrote in message news:3EE5F736.3050505_at_hotmail.com...
> The number of extents on tables may or may not have negative impact,
> however the number of extents on an index definatly will have an impact.
> Simply run statistics (with or without timing) on an index with a
> large number of indexes (100 or more), rebuild the index without the
> extents and run the same process. You will see that the number of reads
> as well as the overall performance of the query is dramatically improved.
>

Hi Sheilah,

Having large numbers of extents in *DD* managed tablespaces can cause issues with regard to overheads and inefficiencies in how the DD manages such metadata. Dropping of such objects for example could prove problematic.

However you've got me puzzled how large numbers of extents impacts the performance of index segments specifically (and "definitely") ?

Can you please offer an explanation as to *why* the number of reads would reduce *solely and purely* because of a reduction of extents ? What is the "same process" you're referring to ?

Hey, I'm always open to new discoveries ...

Cheers

Richard Received on Thu Jun 12 2003 - 08:42:26 CDT