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?
Answer
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).
- Answer
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.