Administrators can reorganize base tables and indexes from the Fragmentation tab in Sybase Central.
Prerequisites
DBA authority.
Context and remarks
Many.
Click the Fragmentation tab.
Connect to the database.
In the left pane, select the database.
In the right pane, click the Fragmentation tab.
Select an object from the top pane. The fragmentation information appears in a dbspace map in the bottom pane:
Choose one of the following methods to reorganize the object.
Click Reorganize to execute a REORGANIZE TABLE statement on the selected object.
Drag an object from the top pane into an Interactive SQL SQL Statements pane. A REORGANIZE TABLE statement for the object appears in the SQL Statements pane. Execute the statement.
This method is useful when you want to reorganize the objects at a later time or when you want to continue using Sybase Central while reorganizing the objects.
Select an object from the top pane, right-click, and click Copy to copy a REORGANIZE TABLE statement for the object into the clipboard. Then, in Interactive SQL paste the statement into SQL Statements pane and execute the statement.
This method is useful when you want to reorganize the objects at a later time or when you want to continue using Sybase Central while reorganizing the objects.
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |