Re: Opinions on multiple extents on tables/indexes

In article <5knbrj$cqa$2_at_news2.alpha.net>, scott.overby_at_sdsdata.com says...
> What is the conventional wisdom on having multiple extents on tables/indexes
> and the effect on performance?
>
>
>
> --
> ==========================================================================
> Scott Overby E-mail scott.overby_at_sdsdata.com
> Sr. Systems Analyst
> Strategic Data Systems FAX (414) 459-9123
> 615 Penn Ave.
> Sheboygan, WI 53082
> ===========================================================================
>
>

Beware of running out of extents either on the table or the index. Often great care is given to the table's space allocation but none to the index. Don't forget to look at the index's allocation - if you use the defaults, you can easily run out of extents for the index.

Fran Edelstein
Author of Learning Oracle Database Programming http://www.rbsbooks.com Received on Mon May 19 1997 - 00:00:00 CDT