On Fri, Oct 06, 2006 at 03:10:01PM -0300, Ezequias Rodrigues da Rocha wrote:
>
> BEGIN WORK;
> delete from base.ticket where session_id = 17 and cash_id = 99 and promo_id
> = 5;
> COMMIT WORK;
Try putting EXPLAIN ANALYSE on the beginning to see what's going on.
That said. . .
> I just think it could be occuring becouse of many constraints (7 at all)
. . .it could be, yes. Are all the other tables &c. indexed
correctly? VACUUMed and ANALYSEd?
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness. --George Orwell