usually we make use of partitioning for easier deletion of data from large tables. That would be fastest and easiest method.
Wherever that is not possible we can create an index on appropriate field(s) and put a logic to do deletion within loop in small chunks.
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page
No comments:
Post a Comment