>> How do I specify a condition for (Column1, Column2) > (1, 2)? Does FB
>> support optimization for the use of compound index?
>
> That is the optimisers job, not something for you to worry about.
>
> where Column1 > 1 and Column2 > 2

How about this:

where Column1 = 1 and Column2 > 2 or Column1>1

Ivan
http://www.volny.cz/iprenosil/interbase/