> Theres any more eficient way to do that? the query takes a
> seconds before result. I solve my insert troubles in
> despachado but have a not liked delay deleting foreign records.

You probably should read this article by Claudio Valderrama
"Declarative referential integrity v/s triggers"
http://www.cvalde.net/document/declaRefIntegVsTrig.htm

As for the speed issue; you may need to ensure you have
appropriate indexes on your data. EXISTS is the correct
and fastest way to do what you appear to want.

--
Geoff Worboys
Telesis Computing