Understanding the Index Selection Tool

Database administrators drop indexes from tables in a physical database to increase system performance. Instead of using the actual database application to drop table indexes, you can use the Index Selection Tool (P95150). The advantage of using P95150 to drop indexes is that EnterpriseOne keeps track of the indexes that are dropped, even if the indexes have been restored or rebuilt. For example, during a software update, the system restores indexes to tables that are affected by the update. Typically, after an update, you would have to perform another analysis to determine the indexes that need to be re-dropped. However, EnterpriseOne retains this information so that you can easily find the indexes that were previously dropped, reducing the time it takes to drop the indexes again.

Note: P95150 should only be used by system administrators or database administrators. Use Security Workbench (P00950) to apply the proper security to this application.

See "Using Security Workbench" in the JD Edwards EnterpriseOne Tools Security Administration Guide.