Rebuilding indexes

[Roger]

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

[Simon Hayes]

"Roger" <ro**********@tiscali.no> wrote in message
news:3i********************************@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

[Paul S Randal [MS]]

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/tre...e/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" <ro**********@tiscali.no> wrote in message
news:3i********************************@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

[Roger]

Hi
Thank you
I'll dig into it

On Fri, 5 Mar 2004 10:28:48 -0800, "Paul S Randal [MS]"
<pr*****@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/tre...e/ss2kidbp.asp