Method 1: Database reconfiguration

With this method, the table is converted in:

  1. Indexes that must be changed or dropped are dropped.
  2. The table is converted by issuing a single SQL ALTER TABLE command to the database.
  3. Indexes that must be changed or created are created.