>
> I have created indexes with certain set of columns. Now I want to remove one of the column and add new column. Can
thisdone without dropping the index?
>
If you intent is to avoid taking that table offline while the index is being built, you can do this:
1. create index concurrently on the new set of columns
2. once (1) done drop old index