I'm looking for a way of deleting rows quicker than the delete dml sentence.
I know truncate sentences, but i don't want to truncate a table or a partition, I want to delete a great number of rows (identified by a where clause), but not a whole partition or table.
For example, inserting rows i can use insert sentences or i can use sql-loader, Ώis there something similar deleting rows??
My problem is deleting time.
Any advice will be greatly apreciatted. Thanks in advance