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.
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
Use the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, double-click Indexes.
Right-click the index and click Validate.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|