Subject Re: [ib-support] Adding index does nothing to select disctinct
> Well, job_number is string so it was
> select distinct job_number from sawmembers
> where job_number <> ''
> and it didn't make it run any faster.

Why a string?

I would have expected job_number to be a number - if you
want it displayed differently I use a calculated field from
the number. That way I get numerical order of job number
what ever the string layout.

I don't know if removing variable length data from the
distinct will help, but since I populate job_number from a
generator I don't need the distinct.

Lester Caine
L.S.Caine Electronic Services