Rebuilding indexes

Hi
I got the advice to rebuild the indexes on the databases once a year.
Espesially if the database have grown much. The question is: How do I
do that?
If I try to run the indexscript wich was run when the databases were
created, I only get the message that the indexes already exists.
Are there a command to automatically rebuild the indexes
automatically?

Roger"Roger" <roger.valand@.tiscali.no> wrote in message
news:3ite40tfa67m2of2qq5m5uc8vlvreilko3@.4ax.com...
> Hi
> I got the advice to rebuild the indexes on the databases once a year.
> Espesially if the database have grown much. The question is: How do I
> do that?
> If I try to run the indexscript wich was run when the databases were
> created, I only get the message that the indexes already exists.
> Are there a command to automatically rebuild the indexes
> automatically?
> Roger

See DBCC DBREINDEX in Books Online, or use a maintenance plan. Once a year
sounds like a very conservative schedule, so you may want to consider weekly
rebuilds if you believe you need them.

Simon|||Checkout the whitepaper below - it will help you decide whether it's even
worth rebuilding the indexes and explain the pros and cons of the different
methods of doing so.

http://www.microsoft.com/technet/tr...ze/ss2kidbp.asp

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"Roger" <roger.valand@.tiscali.no> wrote in message
news:3ite40tfa67m2of2qq5m5uc8vlvreilko3@.4ax.com...
> Hi
> I got the advice to rebuild the indexes on the databases once a year.
> Espesially if the database have grown much. The question is: How do I
> do that?
> If I try to run the indexscript wich was run when the databases were
> created, I only get the message that the indexes already exists.
> Are there a command to automatically rebuild the indexes
> automatically?
> Roger|||Hi
Thank you
I'll dig into it

On Fri, 5 Mar 2004 10:28:48 -0800, "Paul S Randal [MS]"
<prandal@.online.microsoft.com> wrote:

>Checkout the whitepaper below - it will help you decide whether it's even
>worth rebuilding the indexes and explain the pros and cons of the different
>methods of doing so.
>http://www.microsoft.com/technet/tr...ze/ss2kidbp.aspsql