Skip to main content

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?

Hi Erwin,

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).

Hi Jasper,

You are right! I tested it and it works like a charm with smart and full upgrade. The creation process drops the old index and creates the new one. 

Thanks for your reply.

Reply


Terms & ConditionsCookie settings