Hi,

no problem - I guessed it.
This is pretty strange - did you checked that index is active (or "did
ya tried to switch it off and on again" - means deactivate & activate
that index) or another typo hiding us a word "DESC"? :-)

M.

Dne 22.6.2011 13:59, kerryneighbour napsal(a):

>
>
>
> --- In firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>, Milan Tome� - Position
> <tomes@...> wrote:
> >
> > Hi,
> >
> > I cannot see index on ITEMNUMBER column in metadata you've posted. I
> see
> > just ID and ITEMID.
> >
>
> Sorry - having a bad day!! It was a typo on my part. the more correct
> query is
>
> SELECT DISTINCT
> LOCATIONITEMS.ID,
> LOCATIONITEMS.ITEMID
>
> FROM
> LOCATIONITEMS
> ORDER BY
> LOCATIONITEMS.ITEMID
>
>

[Non-text portions of this message have been removed]