Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Indexes


Rebuilding an index

Sometimes it is necessary to rebuild an index because it has become fragmented due to extensive insertion and deletion operations on the table.


You must have DBA authority or be the owner of the table on which the index is created.

Context and remarks

When you rebuild an index, you rebuild the physical index. All logical indexes that use the physical index benefit from the rebuild operation. You do not need to perform a rebuild on logical indexes.

 Rebuild an index using Sybase Central
  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, double-click Indexes.

  3. Right-click the index and click Rebuild.

  4. Click OK.


The index is rebuilt with fragmentation removed.



 See also