Does anybody know how compound index in FB works? I'm working on a web
application that requires the display of a table's records in pages.
The table's primary key is a compound index of 2 fields. What I need to
do is to get a page (around 30 records) of records start from the last
record of the previous page.

How do I specify a condition for (Column1, Column2) > (1, 2)? Does FB
support optimization for the use of compound index?

PK