Too much time to delete 19000 rows

Hi list,

I am having many problems to delete a table with only 19000 rows.

The selection takes less than 1 second but on delete I wait more than 4
minutes and notthing. Can someone tell me what could happen ?

I tryed only one transaction but it does not work too:

BEGIN WORK;
delete from base.ticket where session_id = 17 and cash_id = 99 and promo_id = 5;
COMMIT WORK;

I just think it could be occuring becouse of many constraints (7 at all)

Please any help is welcomed.

Regards
Ezequias

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/