Skip to main content
Solved

How to correctly modify a generated index

  • Oct 9, 2020 8:40 AM UTC
  • 2 replies
  • 147 views
Moderator

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

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

View original

    2 replies

    Jasper
    Thinkwiser
    • Jasper
    • Answer
    • Oct 9, 2020 2:48 PM UTC

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

    Moderator

    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.

      Terms & ConditionsAccessibility statement