Contents Index UPDATE statement [SQL Remote] VALIDATE TABLE statement

ASA SQL Reference
  SQL Statements

VALIDATE INDEX statement


Description 

Use this statement to validate an index, including index statistics.

Syntax 

VALIDATE INDEX [ [ owner.]table-name.] { index-name | table-name }

Usage 

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.

Permissions 

Must be the owner of the table on which the index is created, have DBA authority, or have REMOTE DBA authority (SQL Remote).

Side effects 

None.

See also 

CREATE INDEX statement

VALIDATE TABLE statement

The Validation utility


Contents Index UPDATE statement [SQL Remote] VALIDATE TABLE statement