Subject Re: Some questions about indices
Author fabiano_bonin
> As a workaround, I'd suggest to order by dummy expression (<col> +
0), this
> will disable any possible index navigation and force a SORT plan
instead. It
> should be much better for you, as the filtering is performed before the
> external sorting.

You are right, it improved a lot. Thanks. Do FB2 needs this workaround
also?

Just a note:

In your workaroud, the order column needs to be a number. As in my
application the user chooses the column to order by, and this column
can be of any datatype, this will fit my needs better:

order by
'-', <col>

Regards,

Fabiano.