callmefreud2 wrote:

> We have a query that is fast in the FB 2.0 RC version, but in 2.0 and
> 2.1 takes 20 minutes. Essentially it deletes all records from a table
> in a master detail relationship.
> something like delete from detailTable where not exists (select distict
> masterTable.ID from masterTable where mastertableID = detailTable.FK)
>
> Does anyone know what might have changed significantly after that RC
> version? And will it / can it be fixed.
>
> Thanks
>

Did you read the release notes ???

NOT IN uses a natural scan since it returns wrong results in some
ocasions in priot 2.0 versions tha did a indexed scan.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br