where afield = id
if the afield is indexed, the performance is better.

where afield in (id)
the performance is same (low) with field indexed or not.

correct me if i am wrong.



------------------
ps: sorry for my english (bad)

2009/12/22 Ivan Prenosil <Ivan.Prenosil@...>

> > I was wondering if there is a difference in performance between these 2
> statements :
> >
> > WHERE AFIELD = ID
> >
> > and
> >
> > WHERE AFIELD IN (ID)
>
> No difference, for the engine they are identical.
>
> Ivan
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

--
http://twitter.com/fernandomds
http://fernandomedeiros.com.br/blog


[Non-text portions of this message have been removed]