开发者

Delete SQL server records without reindex

开发者 https://www.devze.com 2022-12-22 12:12 出处:网络
I guess there must be an auto reindex every time a delete takes place. If there are too many deletes for many tables resulting in many records deleted, reindexing will al开发者_JS百科so be time consum

I guess there must be an auto reindex every time a delete takes place. If there are too many deletes for many tables resulting in many records deleted, reindexing will al开发者_JS百科so be time consuming.

Is there any way way to avoid reindexing when deleting records (for it done later in a batch mode)?


There is no auto-reindex after deletes (on any of the mainstream RDBMS's).

Statistics are updated (provided they are not turned off).

Re-indexing is typically a long operation, carried out during maintenance window.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号