Hi list,<br /><br />I am having many problems to delete a table with only 19000 rows.<br /><br />The selection takes
lessthan 1 second but on delete I wait more than 4 minutes and notthing. Can someone tell me what could happen ? <br
/><br/>I tryed only one transaction but it does not work too:<br /><br style="font-weight: bold;" /><pre
class="PROGRAMLISTING"><spanstyle="font-weight: bold;">BEGIN WORK;</span><br style="font-weight: bold;" /><span
style="font-weight:bold;">
delete from base.ticket where session_id = 17 and cash_id = 99 and promo_id = 5;</span><br style="font-weight: bold;"
/><spanstyle="font-weight: bold;">COMMIT WORK; </span><br /><br />I just think it could be occuring becouse of many
constraints(7 at all)
<br /></pre><br />Please any help is welcomed.<br /><br />Regards<br />Ezequias<br clear="all" /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br
/> Atenciosamente(Sincerely) <br /> Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>