Guys,
I need to delete about 1M+ rows of data everyday from a single table, using the 'delete from table where.....' statement will take some time, and the truncate command will delete all the rows in the table.
Can you give me suggestion on how to implement this using the lease possible time. Is there a 'truncate from table where.....' command.
Ed
