Subject | Re: Select how to |
---|---|
Author | sboydlns |
Post date | 2004-09-02T21:31:08Z |
--- In firebird-support@yahoogroups.com, Lucas Franzen <luc@r...> wrote:
problem to see it. I'll give it a try. Thanks.
>I knew that there had to be a way to do it but I was too close to the
> Have you considered replacing the
>
> SELECT ... FROM table1 where table1_key IN (...)
>
> with
>
> SELECT ... FROM table1 where EXISTS (...)
>
>
> I don't know a faster way than that.
>
> Luc.
problem to see it. I'll give it a try. Thanks.