32

An INDEX was added to the SalesTable, causing the retrieval of data on the screen to take more than 20 minutes.


The customer confirmed that the addition of the INDEX resulted in poor performance in the sandbox environment, and performance improved by removing the INDEX. However, in the production environment, the customer is unable to remove the INDEX.


Since there are cases where adding an INDEX for performance optimization deteriorates performance, please add a feature that allows the customer to delete the INDEX.


And, please add a parameter that allows to select any table and lock it from performance optimization.

For example, adding INDEX to a table with a large amount of data, performance optimization or DAMS will likely cause performance issues.

Category: User Experience
STATUS DETAILS
New