We have a table with Row level locking with 60Million rows.
The indexes grow about 300MB a day. It is a table with a lot of inserts and deletes, But no updates.
When we do a reorg rebuild on the table we gain about 10GB in space back.
However this is a 24/7 system. How do we get around rebuilding indexes in a 24/7 system.
Sybase version is 11.9.2 (Application people to busy implementing new functionality to upgrade!)