| Subject | Re: [firebird-support] Re: two machines - different resultsets for ORDER BY |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2006-05-22T12:13:30Z |
> Give the following a try:Or set it Inactive / Active.
>
> 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.
Ivan