yeah , This is the best solution, Where you dont need much resources and DB to do more work, You will save a lot here.
Just simple inserts from base table to new table with your condition,
verify ,
rename base table to some other, new table to base tablename.
analyze this table.
On Tue, Mar 29, 2011 at 9:34 PM, Plugge, Joe R.
<JRPlugge@west.com> wrote:
Personally, provided you have the room, I would build a new table off to the side and then migrate what you need to keep to the new table, when done, and satisfied that you have all of the candidate rows, ranem the original to table to "x_tablename" and rename the newly created table into place to take over.... if all is good .. simply drop the x_tablename table.