Administrators can reorganize base tables and indexes from the Fragmentation tab in Sybase Central.
You must be the owner of the object or have the REORGANIZE ANY OBJECT system privilege.
In Sybase Central, use the SQL Anywhere 16 plug-in to 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.
Copy 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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|