Add a new index in to my table

11 Aug 2005 8:55 PM

Souris

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,

11 Aug 2005 10:57 PM

Wayne Snyder

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

Show quote

"Souris" <Sou***@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,