unused space in extent and performance

From: rob <rob_at_dsdelft.nl>
Date: Fri, 24 Apr 1998 18:52:22 +0200
Message-ID: <6hqg5r$h23$1@news.worldonline.nl>

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. Received on Fri Apr 24 1998 - 11:52:22 CDT