Hello,

I use something like this:
...
Where field1 in (select field2 from table2)

table2 has about 50 records. Why does it so dramaticly slow down
query, even if I write all these values without doing subselect.

Next question. If subselect is constant (like in my example), how many
times firebird executes it?