The main features of ALTER TABLE RENAME INDEX statement are:

  • ALTER TABLE RENAME INDEX is an online and offline operation.
  • ALTER TABLE RENAME INDEX is an offline operation for instances where:
    • Table is in PUB schema.
    • Database is enabled for OpenEdge Replication.
  • ALTER TABLE RENAME INDEX is an online operation for tables defined in a non-PUB schema.

Impact

When ALTER TABLE RENAME INDEX is performed, the following are impacted:

  • Progress Developer Studio for OpenEdge — Progress Developer Studio for OpenEdge can fetch table and index definitions, and display them to perform database operations.

    When you perform online ALTER TABLE RENAME INDEX, in concurrent transaction, and when Progress Developer Studio for OpenEdge fetch the data using old index name, then it might return Index not found error.

  • Database utilities — When you perform online ALTER TABLE RENAME INDEX in concurrent operation with database utilities or index utilities (IDXcheck,IDXfix), they might result in lock conflict.