SQL administration: Which SQL statement is used to change an index’s future storage parameters (for example, in systems that support storage clauses)?

Introduction / Context:
Production databases require ongoing maintenance of indexes, including rebuilding, moving to different tablespaces, or adjusting storage parameters. Administrators use Data Definition Language (DDL) to manage these tasks, and the correct command depends on the RDBMS dialect.

Given Data / Assumptions:

• We seek the canonical DDL verb used to change an index definition.
• Many enterprise systems (e.g., Oracle) support storage clauses on indexes that can be altered.
• Non-standard verbs are distractors.

Concept / Approach:
The standard DDL pattern for changing existing objects is ALTER