You can validate an index on Adaptive Server 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 complements the validity checking carried out by the Adaptive Server 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.
dbvalid -i EmployeeIndex
For more information, see Sybase IQ Utility Guide.
