Home Forums SQL Server 2008 SQL Server 2008 - General How to speed up purge process RE: How to speed up purge process
Ken Davis
SSCarpal Tunnel
Points: 4329
More actions
January 30, 2015 at 1:29 pm
#1774469
The process is making pretty good use of indexes. It is only seeks and it's a seek on the nonclus index on ID for the TD table. I will try to attach the query plan.
The ratio is about 2 TD rows to 1 T row.