I have a history table that contains 3 months of data. Can I drop the existing index built on (a, b, c) and recreate an index on different columns like on (a, b, d, e). Does this affect data. Are there any steps that I have to follow in sequence.
What are the required steps that I have to follow.
Please advise asap!