Indexes

when dropping and recreating indexes, is there anything else that needs to
be done?
I keep hearing the phrase rebuilding indexes...
thanks
What we in the SQL Server world refer to as rebuilding an index means that we try to defragment the
index, for performance reasons.
This is typically done using the DBCC DBREINDEX command (in 2005 we use ALTER INDEX with the REBUILD
option instead). This means that SQL Server under the covers create a new index and then drop the
old one.
An alternative method is DBCC INDEXDEFRAG (ALTER INDEX with the REORGANIZE option). This work
differently internally.
See Books Online for details of what these commands does.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"g" <gregoranton_nospamplease_@.hotmail.com> wrote in message news:an3If.8988$bd4.6488@.edtnps84...
> when dropping and recreating indexes, is there anything else that needs to be done?
> I keep hearing the phrase rebuilding indexes...
> thanks
>
|||Thanks Tibor!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OK5j2UMMGHA.1760@.TK2MSFTNGP10.phx.gbl...
> What we in the SQL Server world refer to as rebuilding an index means that
> we try to defragment the index, for performance reasons.
> This is typically done using the DBCC DBREINDEX command (in 2005 we use
> ALTER INDEX with the REBUILD option instead). This means that SQL Server
> under the covers create a new index and then drop the old one.
> An alternative method is DBCC INDEXDEFRAG (ALTER INDEX with the REORGANIZE
> option). This work differently internally.
> See Books Online for details of what these commands does.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "g" <gregoranton_nospamplease_@.hotmail.com> wrote in message
> news:an3If.8988$bd4.6488@.edtnps84...
>