tags:

views:

90

answers:

1
+2  Q: 

Delete SQL server records without reindex

I guess there must be auto reindex everytime a delete takes place. If there are too many deletes for many tables resulting in many records deleted, reindexing will also be time consuming. Is there any way where reindexing is avoided in delete and it's done later in a batch mode?

+4  A: 

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.

Mitch Wheat  2010-03-05 06:52:17
Thanks. Is there any way to supress the statistics (turn off) so that time is saved there too?
KP  2010-03-05 08:01:44
You can turn off auto updating of statistics, but it will most likely be detrimental to performance.
Mitch Wheat  2010-03-06 15:46:52

related questions

How do I cancel a Delete in SQL
Binary Search Tree Deletion (Inorder Pred method) C++
Automatically Remove Subversion Unversioned Files
Use C# to delete files from remote computer
Is it possible with Java to delete to the Recycle Bin?
How to use PHP to delete X number of lines from the beginning of a text file.
Virus scanners locking and deleting temporary files - best way to cope with them?
SQL Server xp_delete_file not deleting files
How to undo a delete operation in SQL Server 2005?
Hibernate Delete Cascade
Delete Folder Contents in Python
In what cases do I use malloc vs new?
JavaScript bookmarklet to delete all cookies within a given domain
What is the best way to delete a value from an array in Perl ?
SQL Duplicate Delete Query over Millions of Rows for Performance
SQL Server Query Question: If I stop a long running query, does it rollback?
SQL Query: Remove Duplicates with Caveats
MySQL5: Delete all but the 50 newest rows
How to remove duplicate elements from an xml file?
Does CASCADE Delete execute as transaction?
File and directory with same name in same parent directory - Solaris 8, ufs
Why overwrite a file more than once to securely delete all traces of a file?
DELETE Statement hangs on SQL Server for no apparent reason
Batch file to delete files older than N days
SQL Delete: can't specify target table for update in FROM clause