Thursday, February 16, 2012

Add a new index in to my table

I wanted to inprove my database performance to add a new index in my table.
I just wanted to know are there any impact and should I add index without
any activities on the database?
Thanks millions for the informaiton,You can add an index when people are using the system, but be aware that the
entire table will be read to create the index, so they may see a performance
impact...
If you CAN wait until the evening, you probably should. but it is not the
end of the world.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Souris" <Souris@.discussions.microsoft.com> wrote in message
news:99EEC771-1D7C-45EE-A086-70C199A7DA2E@.microsoft.com...
>I wanted to inprove my database performance to add a new index in my table.
> I just wanted to know are there any impact and should I add index without
> any activities on the database?
> Thanks millions for the informaiton,

No comments:

Post a Comment