The reorganization templates help you keep your database organized, avoiding lost table space and noncontiguous table data.
Sybase rebuild indexes template This template runs the reorg rebuild command on an index or indexes for a table. You must specify the database, table, and indexes required by the reorg rebuild command. You can also specify an index partition name and a database backup after the reorg rebuild command executes.
Sybase rebuild tables template This template runs the reorg rebuild command on the entire table. You must specify the database and tables required by the reorg rebuild command. You can also specify to back up the database after the reorg rebuild command executes.
Sybase reclaim index space template This template reclaims unused space left on a page as a result of deletions and updates that shorten rows. It invokes the reorg reclaim space command to reorganize an index’s data pages. If you specify more than one index, space is reclaimed for each index. You can also specify the name of the index partition that contains the specified index.
Sybase reclaim table space template This template reclaims unused space left on a page as a result of deletions and updates that shorten rows. It invokes the reorg reclaim space command to reorganize a table’s data pages. If you specify more than one table, space is reclaimed for each table. You can provide a partition name to limit the reorg reclaim space command to that partition of the table on the specified partition. You can also specify a partition name to limit reorganization to a partitioned portion of a table.
