> > I have created indexes with certain set of columns. Now I want to remove one > of the column and add new column. Can this done 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
