Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: AUTOEXTEND
On 10/4/05, Michael McMullen <ganstadba_at_hotmail.com> wrote:
>
> How does autoextend relate to full table scan (FTS)? Or, is it bad to FTS
> the tables that caused multiple autoextends?
>
>
If you know a table will be large, and will be subject to FTS, allocating
the
space all at once will make it contigous.
The impact of not doing so is probably not all that bad. It is much like the multiple extents argument. ie. you usually don't need to worry about it.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 04 2005 - 16:32:00 CDT
![]() |
![]() |