Indexes on Foreign key/Look up columns
I noticed that by default Creatio adds a Non-Unique/Non-Clustered index on all foreign key columns (Look up references). Want to understand this better.
Indexes can be detrimental when there is a lot of Writes into that table as compared to Reads. This effect gets multiplied when a Table has 5 or more look up reference columns.
1. Are these indexes Mandatory for the functioning of Creatio?
2. Will there be any side effects (Apart from performance implications) to removing these indexes on a case by case basis - After evaluation of whether table has more Read vs Write frequency.