VERIFIED SOLUTION i

Can a new database index be added against an existing table in Portrait Foundation?

Product Feature: Database
 
Adding or altering indexes in the Portrait Foundation database is not a supported activity.

Portrait Foundation's database uses a metadata-driven schema which means that adding new indexes can be quite wasteful.

Each new release tends to have its own set of database performance improvements that have been tested alongside implementations. Adding an unsolicited new index without Portrait Support's approval may slow down your overall database performance as it will increase the overall size of the database and will reduce the insert and update performance on affected tables and views.

Any customer who wishes to add a new index - or remove an existing one - should contact Support with their performance calculations and reasons for requesting this.
UPDATED:  April 18, 2017