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.�
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.�
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.�
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
