Delete SQL server records without reindex

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.