Subject Re: [firebird-support] Re: two machines - different resultsets for ORDER BY
Author Ivan Prenosil
> Give the following a try:
> ORDER BY StringField || '' ASC, IDField+0 DESC
> This will prevent any index from being used in the ordering, and
> should tell you whether you have a corrupt index. If so, drop the
> ind(ex)/(ices) and redefine them.

Or set it Inactive / Active.