how to do more efficient a delete stament
Hi Guys
The delete statement i 'd like to try does a purge of more than 16M rows
select * from baan.tfxinh115377 where t$koor = 0 and t$ityp = 3 and t$attr = 98
COUNT(1)
----------
16581349
Probably I 'll use
delete from baan.tfxinh115377 where t$koor = 0 and t$ityp = 3 and t$attr = 98;
but the issue it would be the undo right; I've doing a research on it could be and i guess one it could be this
set serveroutput on
declare
VCOUNT number :=0;
cursor c1 is select * from baan.tfxinh115377 where t$koor = 0 and t$ityp = 3 and t$attr = 98;
begin
for c1rec in c1 loop