Choose Utilities > Index Deactivation to deactivate indexes. When you choose this option, the Index Deactivation Warning dialog box shown in the following figure appears.
Figure 69. Index Deactivation Warning dialog box
After you read the information, choose OK. The Data Dictionary alphabetically lists all the tables defined for the database. Select the table for which you want to deactivate indexes or enter ALL to deactivate all your indexes. If you specified an individual table, the Data Dictionary lists the indexes defined for that table. Select the indexes you want to deactivate, then press GO. The Data Dictionary prompts you to verify your entry.
