Very Computer

I'am working on a data warahouse. The initial extents of tables and indexes
are sized to contain 5 years of data. For example: the largest table will be
about 2 GIG but now is filled with only 200MB of data.  Does a large ammount
of free space in the initial extents have a negitive effect on performance.

I have the feeling that choosing a more conservative initial extent will
benefit the performance in the first years. Ofcourse this will need
reorganising tables wen they are becomming to fragmented.

All comments are welcome
Rob.

Hi,
    Till your high water mark is set at 200Mega, there isn't any overcosts.
    The only trouble is disk waste.
        Backup and restore slower.
        Disk already bougth at the beginning of the project.
        ...

--
Regards F. Lange Certified DBA.
29A route du vin.
L5450 Stadtbredimus.
Grand Duchy of Luxembourg.

(int) 352 697412
(cel) 352 021193652
Phone numbers are variable length.
Luxembourg is a small country of 80 miles on 60 miles between France,
Germany and Belgium.

Quote:>I'am working on a data warahouse. The initial extents of tables and indexes
>are sized to contain 5 years of data. For example: the largest table will
be
>about 2 GIG but now is filled with only 200MB of data.  Does a large
ammount
>of free space in the initial extents have a negitive effect on performance.

>I have the feeling that choosing a more conservative initial extent will
>benefit the performance in the first years. Ofcourse this will need
>reorganising tables wen they are becomming to fragmented.

>All comments are welcome

Cheers,
Nevin Hahn