Alter an index in DB2

[srilata83]

Hi,

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????

Please suggest me.

Thanks in advance.

[vijay2082]

you can drop the index and recreate it. Don't forget to perform a runstats on the table. Also keep in mind the time taken to create the index and runstats on the table, if its a huge table.

Vijay