Expurgo de uma Tabela

[rmanParticipante]

Creio que assim o custo do DELETE seja menor.


CREATE OR REPLACE PROCEDURE QUEUE_PURGE() AS
BEGIN
DELETE FROM QUEUE WHERE TO_CHAR( DATE_INSERTED, 'YYYYMMDD' ) <= TO_CHAR( (SYSDATE - 7), 'YYYYMMDD' );
);
END QUEUE_PURGE;