Helen Borrie wrote:

>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, it seems like never end, Thanks for you help, im seriously
thinking in use another engine. Is a amazing amount of work (one index,
three triggers, and who know what more) for do some must be so simple.

best regards.

german.