purge records
-
Hi all
Currently we are doing a purge exercise on a database of about 13 Gb. The purge tool is supplied by vendor.
Question is when purging records ( which we believe are removed and not just moved with database ) do I need to do anything to the indexes of the tables , or would the purge \ remove alter the indexes already ?
Anything I can check , look for etc ?
many thanks
-
You can trace the purge with Profiler and see if things are removed or moved. That would be handy to know.
Indexes might need rebuilding to remove fragmentation in either case. Statistics might need to be updated manually to ensure good performance after the exercise.
-
I'm sure that I'm preaching to the choir, but I gotta say it... make sure you have an up to the minute full backup of the database (maybe even a hot standby server) before you let any 3rd party vendor near your system.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply