Modifying Indexes, CALC Keys, and Referential Constraints › Maintaining Indexes › Changing Index Characteristics/Moving an Index

Changing Index Characteristics/Moving an Index

To modify index characteristics or to move an index from one area to another, use the SQL DDL ALTER INDEX statement.

Types of Changes You Can Make:

The following attributes of a referential constraint can be changed:

• Index block specification
• Index uniqueness
• The area in which an index resides

Statements That Modify Indexes:

To modify index attributes, use the ALTER INDEX statement.

Considerations

• If changing index tuning options, remember to observe referential constraint rules.

Example: Index altered on the BENEFITS table

alter index emp_lname (last_name) on emp.benefits
      displacement is 40 pages
           index block contains 30 keys
      in area emp.emp1;