I have to alter an index by adding two columns into it.
My table contains data and according to the requiremnet the data must be preserved.
So i am dropping the index and creating the index with two new columns.
Is that enough?But do i need to do anything with data????