Validating Catalog Store Indexes

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.

To validate an index, open a command prompt and run the dbvalid utility.
For example, the following statement, which should be typed on a single line) validates an index called EmployeeIndex. The -i switch specifies that each object name given is an index.
dbvalid -c "uid=dba;pwd=sql;eng=myserver" 
-i EmployeeIndex
Next
See dbvalid Database Administration Utility in the Utility Guide.