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.
Validate tables or entire databases only when no connections are making changes to the database.
Use the SQL Anywhere 12 plug-in to 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.
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.
Run a dbvalid command with the -i option specified.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|