Index Validation

You can validate an index on SQL Anywhere tables in the catalog store to ensure that every row referenced in the index actually works in the table.

For foreign key indexes, a validation check also ensures that the corresponding row exists in the primary table, and that their hash values match. This check is equivalent to the validity checking carried out by the SQL Anywhere VALIDATE TABLE statement.

To validate an index, open a command prompt and run the dbvalid utility.

For example, the following statement validates an index called EmployeeIndex. The -i switch specifies that each object name given is an index. (Type the command on one line.)

dbvalid -c "uid=dba;pwd=sql;eng=myserver" 
-i EmployeeIndex

See Utility Guide > dbvalid Database Administration Utility.