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