I would like Sybase to introduce into ASE the ability to
specify for a tables/indexes a block used pctg. That is
specify the maximum full that a block can be before row
migration and/or page splitting. In addition, introduce a
column in sysindexes called reorged since last max block
used size changed. With this information ASE could perform
fast changes to tables with ALTER TABLE even if adding a not
nullable column or expanding an existing column
(potentially). That is, if the new space added would not
exceed the block free pct (reset reorged since last max
block used size changed, because an alter table is allowed
to exceed the max block used size). No full reorg would
need to be performed and no pages would move.

Benefit: Very fast table changes, reducing outage times.

Ryan Putnam