I want to add a column to the include columns of a generated index from a reference. I could create a new index, but then I would have index on column A and index on column A with include column B. Since having too many indexes is not optimal for SQL server I want the existing reference index to have the include column. How do you correctly modify an existing index created by a reference? Is there a way to do this in the sf without resorting on the dynamic model?
Best answer by Jasper
If I’m correct the Software Factory will not generate a new index if there’s an existing index that would cover it (containing at least the same columns in the exact same order).