At 10:55 AM 4/10/2004 +1000, Geoff Worboys wrote:

>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.

However, to avoid falling straight back into the same hole that your custom
RI triggers are supposed to dig you out of, DO NOT MAKE A SINGLE-COLUMN
INDEX on despachado.idbomba. Instead, do

create index cfk_idbomba on despachado(idbomba, pk)

where the column pk is (hopefully) the single-column primary key column of
despachado.

./heLen