Support Questions

Find answers, ask questions, and share your expertise

Add one more column to a Phoenix Covered Index

I have an existing covered index which I created using statement like below.

CREATE INDEX my_index ON my_table (v1,v2) INCLUDE(v3).

Now I want to include one more column v4, like  INCLUDE(v3,v4).  v4 column will not be part of actual index but it will be in covered part.
I am not sure if we have an Alter statement to do this. Request for assistance.
1 ACCEPTED SOLUTION

Super Collaborator

No, there is no alter for index. The problem is that adding one more column to the index means the same full scan over the table and the operation would be as expensive as the new index creation.

View solution in original post

2 REPLIES 2

Super Collaborator

No, there is no alter for index. The problem is that adding one more column to the index means the same full scan over the table and the operation would be as expensive as the new index creation.

I don't want to add one more column to the actual index columns, but in the INCLUDE() section. Will that also have same effect?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.