Printable View
depending on the size of your table the fastest way to delete these rows would be to:
1) insert into a temp table all the rows you want to keep
2) truncate your table
3) reinsert all data from your temp table
Of course you can only do it this way if there are no FK referencing your table.
That's interesting approach. Isn't it true if the partition of the data to be deleted is bigger that these to be held?
Actually if one uses direct load insert here and suppress the redo, that could really be faster
Agree with both mike9 and bore but... as per original post -OP- doesn't even know how to put together a WHERE clause, he wouldn't understand what you are saying guys.