Arno Brinkman wrote:

> At which point (layer) do you expand the list (represented as string) into the new evaluation items
> ((ID BETWEEN 5 and 10) or (ID BETWEEN 20 and 30) or (ID = 50))?
>

In the optimizer.

> If i correctly understand this wouldn't be able to use an index on ID.
>

It could be handled for index walk as BETWEEN X AND Y, with X being the
lesser and Y being the higher value of the list.


Adriano