question Re: Add one more column to a Phoenix Covered Index in Archives of Support Questions (Read Only)

Add one more column to a Phoenix Covered Index

akash_sabarad — Tue, 24 Oct 2017 21:42:48 GMT

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.

Re: Add one more column to a Phoenix Covered Index

ssoldatov — Wed, 25 Oct 2017 01:37:09 GMT

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.

Re: Add one more column to a Phoenix Covered Index

akash_sabarad — Mon, 30 Oct 2017 22:02:16 GMT

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?