Hi folks,


I just had a brief question.

I remember from Helen Borrie's book that it said that the IN()
predicator doesn't use indexes to select the results. However, I know
this is old data.

The question is, does this still apply, and if it does are there any
plans to change/fix this to use indexes?

If it does still apply, what would be the recommended equivalent
approach in SQL to take instead to maintain a useful level of performance?


Kind regards,


Scott :)