Re: number of extents question

Thank You *very much*, Pablo, for this post. The document goes to option 2, but
I never found something comparable in details. Wow!

Jan=)

"Pablo Sanchez" <pablo_at_dev.null> schrieb im Newsbeitrag news:Xns928591663716Epingottpingottbah_at_192.168.1.1...
> "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
Received on Wed Sep 11 2002 - 08:55:24 CDT