Re: number of extents question

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in news:alli1a$1ppeaj$1_at_ID-152732.news.dfncis.de:

> Does it or does it not matter (that is: decreasing my performance)
> having 1, 10 or 200 extents for one index segment (and BTW, same
> question for tables) ?

I think the best write-up I found on this was done by some folks at Oracle. A quick google search found it at the following site:

         http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm

It's a good read.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com