Validating an index

You can validate an index to ensure that every row referenced in the index actually exists in the table. For foreign key indexes, a validation check also ensures that the corresponding row exists in the primary table.

Prerequisites

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

Perform validation only when no connections are making changes to the database.

Context and remarks

Many.

 Validate 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 Validate.

  4. Click OK.

Results

A check is done to ensure that every row referenced in the index actually exists in the table. For foreign key indexes, the check ensures that the corresponding row exists in the primary table.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1