Chapter 9 SQL Statements
643
VALIDATE INDEX statement
Use this statement to validate an index.
VALIDATE INDEX [ [
owner
.]
table-name
.]{
index-name
|
table-name
}
Must be the owner of the table on which the index is created, have DBA
authority, or have REMOTE DBA authority (SQL Remote).
None.
"CREATE INDEX statement" on page 448
"VALIDATE TABLE statement" on page 644
"The Validation utility" on page 148
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, and that their hash values match. This check complements
the validity checking carried out by the VALIDATE TABLE statement.
index-name | table-name If you supply a table-name instead of an index-
name, the primary key index is validated.
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...