Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Is it possible to create custom indexes in the database?

  1. Last updated
  2. Save as PDF

Is it possible to create custom indexes in the Changepoint database, or could this cause any issues with the business functionality of the application?

It is possible to add new custom indexes to the Changepoint database, but a few points need to be taken into account:

  • The index must be non-unique and non-clustered
  • While improving performance on Select statements, more indexes slow down insert, update and delete operations
  • It is recommended to remove any custom index before an upgrade of the application, as the custom index might interfere with the upgrade procedure

 

As a database index is a modification of the physical storage structure, it does not cause any changes in the logical/business behavior of the Changepoint functionality.