Delete statement very slow
938302Jan 25 2013 — edited Jan 29 2013Hi Team,
I have a DB 9.2.0.7 ON Unix,
e have a performance issue the delete statements on the database are running very slow they are taking about 5 hours.
delete from FACT_VENTAS_DIA where ID_FECHA between to_date('01/01/2008','DD/MM/YYYY') AND TO_DATE('15/01/2008','DD/MM/YYYY');
And the delete doesn't end.
Regards,
Guido