Martijn Tonies wrote:

>
> However, it does raise a question -- what happens with the
> Firebird optimizer if there's a bunch of columns in the WHERE
> clause and none of them have indices.

Table size enters into it, if the columns are in different tables
the smaller table is evaluated first. For columns in a single
table, it really doesn't matter. In the absence of any indexed
access, the whole table will be read.


Regards,


Ann