Using sort option when reindexing a

[Guest_imported]

Normally we assign disk space of about 120% of the table that we are doing maintenance on. Once assigned, it is commiteed forever to that segment. When there is a clustered index, I understand we can use the "sort option" that would allow us not to assign so much space - probably in the the area of 10 %. Is this correct?

 

[Tim1]

Hi,

You can determine how much space you need to allocate by the fill factor. The higher that you set this value, the less "wasted" space there will be on your disk.

However, the overhead of maintaining the table, both in terms of updating the key fields, or inserting new rows, will be higher, as it has more data that it has to physically move to make room for the new rows.

As with most things in Sybase, it is a case of playing around with some different values for a while until you end up with the best compromise for yourself.

Tim