Hi,

> I remember from Helen Borrie's book that it said that the IN()
> predicator doesn't use indexes to select the results.

Are you sure? Didn't she said that NOT IN do not use indexes? IN do use
indexes (at least in FB v1.5). Note that IN (a, b, ..) is equivalent to 'a
OR b OR ...'.

> what would be the recommended equivalent
> approach in SQL to take instead to maintain a useful level of performance?

Althougt IN does use indexes -- once for each value in the list --, in some
circunstances it's good idea to apply some other better condition together,
if possible.


Regards,
Anderson Farias