Subject | Re: Some questions about indices |
---|---|
Author | fabiano_bonin |
Post date | 2005-08-17T18:09:21Z |
> As a workaround, I'd suggest to order by dummy expression (<col> +0), this
> will disable any possible index navigation and force a SORT planinstead. It
> should be much better for you, as the filtering is performed before theYou are right, it improved a lot. Thanks. Do FB2 needs this workaround
> external sorting.
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.