Solved

How to correctly modify a generated index

  • 9 October 2020
  • 2 replies
  • 102 views

Userlevel 6
Badge +16

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?

icon

Best answer by Jasper 9 October 2020, 16:48

View original

2 replies

Userlevel 7
Badge +11

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

Userlevel 6
Badge +16

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