Validating indexes

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. This check complements the validity checking performed by the VALIDATE TABLE statement.

Caution

Validate tables or entire databases only when no connections are making changes to the database.

To validate an index (Sybase Central)

Connect to the database as a user with DBA authority, or as the owner of the table on which the index is created.
In the left pane, double-click Indexes.
Right-click the index and choose Validate.
Click OK.

To validate an index (SQL)

Connect to the database as a user with DBA authority, or as the owner of the table on which the index is created.
Execute a VALIDATE INDEX statement.

To validate an index (command line)

Run the dbvalid utility.

Examples

Validate an index called EmployeeNames. If you supply a table name instead of an index name, the primary key index is validated.

VALIDATE INDEX EmployeeNames;

Validate an index called EmployeeNames. The -i option specifies that each object name given is an index.

dbvalid -i EmployeeNames

See VALIDATE statement, and Validation utility (dbvalid).

Send feedback about this page via email or DocCommentXchange