--- In firebird-support@yahoogroups.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