ASA SQL Reference
SQL Statements
Use this statement to validate an index, including index statistics.
VALIDATE INDEX [ [ owner.]table-name.] { index-name | table-name }
Ensures that every row referenced in the index actually exists in the table. For foreign key indexes, it also ensures that the corresponding row exists in the primary table. This check complements the validity checking carried out by the VALIDATE TABLE statement.
The VALIDATE INDEX statement also verifies that the statistics reported on the specified index(es) are accurate. If they are not accurate, an error is generated.
index-name | table-name If you supply a table-name instead of an index-name, the primary key index is validated.
Must be the owner of the table on which the index is created, have DBA authority, or have REMOTE DBA authority (SQL Remote).
None.