Imapct on indexes if schema updated

Question

Imapct on indexes if schema updated

amita.gham

Newbie

Points: 1
More actions
March 29, 2012 at 4:01 pm

#258420

Hi Team,
I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table with no issue to existing index ?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

amita.gham (3/29/2012)
I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table with no issue to existing index ?

As far as you do not touch the indexed columns - no problem.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

CapnHector SSCoach Points: 16143 More actions · Answer 2

PaulB-TheOneAndOnly (3/29/2012)
amita.gham (3/29/2012)
I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table with no issue to existing index ?
As far as you do not touch the indexed columns - no problem.

there SHOULD not be any impact. however if you add a clustered index on the new columns that may mess with any non clustered indexes.

to be safe after you make the changes i would schedule a job to rebuild the indexes on the table.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

capn.hector (3/29/2012)
PaulB-TheOneAndOnly (3/29/2012)
amita.gham (3/29/2012)
I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table with no issue to existing index ?
As far as you do not touch the indexed columns - no problem.
there SHOULD not be any impact. however if you add a clustered index on the new columns that may mess with any non clustered indexes.
to be safe after you make the changes i would schedule a job to rebuild the indexes on the table.

Hey Hey ... poster clearly states is just adding two columns, no mention about creating a clustered index on them. 😀

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.