"vj_dba" <vi******@gmail.comwrote in message
news:11*********************@d34g2000cwd.googlegro ups.com...
Hi group,
I have a table say with 10000 records and 10 columns initially, I
created an index say i1, after few days I altered the table by adding
10 new columns and 90000 rows of records summing up to 100000 records.
My doubt is regarding the index is Do I have to create a new index ? or
can I use the same index which I created first, or do I have to make
any changes to existing index like rebuild etc...?
What needs to be done for the index...
Thanks in advance,
VJ
Since the index comprised of one or more of the original 10 columns, if you
add new columns the index you created is still there and does not have to be
recreated or changed in any way (assuming that the columns are still correct
and you do not need any of the new columns in the index).
Anytime you alter a table and add new columns, it is best to reorg the
table. The reason is that adding new columns does not add space for the
columns until you try to update the row, which could get messy since the row
will probably not fit back in the same space where it was. But this is
strictly a performance issue.
A regular (offline) reorg on the table will reorg the table and all indexes.