If the plan is the same I would say performance will be the same. Why not
test this yourself?

I tried:
select * from investments where id = 51 /* where id = PK */
Plan:
PLAN (INVESTMENTS INDEX (RDB$PRIMARY61))
then with the in statement
PLAN (INVESTMENTS INDEX (RDB$PRIMARY61))

I don't know whether it would make a difference if there were other elements
in the where clause, i.e. FB thinks that in is a expensive operation as it
implies there will be a sequence of "OR" statements.

JAC.


<mikeevteev@...> wrote in message news:av50ah+rhgg@......

> Hi all!
>
> what is difference in performance between quieries with only one
> condition diffrent
> one query has id = 0 another one is in (0). Notice only one value in
> both cases.
>
> Mike
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>