Best way to delete million records

Hi all,

I have to delete about 43 millions rows from a table, but the following conditions exist:

• The table is not partitioned and unfortunately I can't modify the structure
• The delete procedure must be done without stopping service, so I can't use CTAS, moving records and renaming table.
• I can't use truncate because the records affected are selected in a range of dates

Waiting your suggestions and probable problems for this procedure.

Thanks for help.

Bye Received on Mon Jun 30 2008 - 03:00:51 CDT