Tuesday, March 27, 2012

dropping and recreating a table

I recall reading somewhere that there are benefits to dropping and
recreating the table, then recreating it's indexes. This is as opposed to
just dropping and recreating the indexes.
Thanks
--
Regards
JTC ^..^I don't know that there are any advantages to this that you couldn't get via
DBCC statements... Maybe some defragmentation benefits, but you should be
able to get those via DBCC w/o dropping the table...
"JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
news:Xns9620E1385E1A7daveJTC@.217.32.252.50...
>I recall reading somewhere that there are benefits to dropping and
> recreating the table, then recreating it's indexes. This is as opposed to
> just dropping and recreating the indexes.
> Thanks
> --
> Regards
> JTC ^..^

No comments:

Post a Comment