Tune a delete stament
Hi guys
i want to tune a delete with select condition statement
this is the condition
select *
from baan.tfxinh115377
where t$koor = 0 and t$ityp = 3 and t$attr = 98;
and they are around 16M rows (16581349)
Do you recommend this statement or there is some way to improve it?
delete from baan.tfxinh115377
where exists
(select * from baan.tfxinh115377
where t$koor = 0 and t$ityp = 3 and t$attr = 98);
Jesus