Indexes

13 Feb 2006 5:30 PM

g

when dropping and recreating indexes, is there anything else that needs to
be done?

I keep hearing the phrase rebuilding indexes...

thanks

13 Feb 2006 5:45 PM

Tibor Karaszi

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/

Show quoteHide quote

"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
>

13 Feb 2006 7:55 PM

g

Thanks Tibor!

Show quoteHide quote

"Tibor Karaszi" <tibor_please.no.email_kara***@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...
>> when dropping and recreating indexes, is there anything else that needs
>> to be done?
>>
>> I keep hearing the phrase rebuilding indexes...
>>
>> thanks
>>
>