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

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