> Hi Miroslav,
>
> You got a nice answer here, but concerning on what svein erling posted,
> if I had 1=0 will this scan the whole table and slow down the whole thing?

It will prevent the index on FieldA from being used. Indexes outside the
parenthesis around (1=:ACTIVE_FILTER OR FieldA =:ANY) can still be used.

Though didn't you write something about using IBO? If so, I think IBO has search
mechanisms implemented already and you may be trying to reinvent something.

Set