Use the Drop page of the Index SmartGuide to select the existing indexes to be dropped. The workload you specified did not use these indexes. If your workload is well-defined, you can drop these indexes to save the disk space.
| Note: | Keep these indexes if they are needed for activities or transactions that are not part of the workload. If you drop all the indexes, the consequences will be that any database activity that needed those indexes will run slower. The advantage will be that the SQL statements in the workload will run faster. |
Fields and controls
Related information