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?
Solved
How to correctly modify a generated index
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).
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.