--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> * You forgot to use
> ORDER BY Column1, Column2
> clause.
>

I've tried that already but it doesn't help much. I even tried forcing
the plan by adding PLAN(my_table index my_index_name).

> * How many records are there for Column1=1 ? Instead of
> ... where column1 > 1 ...
> try this one
> ... where column1 >= 2 ...
>

There are 100 records for Column1 = 1.