Thomas Miller wrote:

> Not that this will work, but try this
>
> SELECT DISTINCT(JOB_NUMBER) FROM SAWMEMEBRS
> WHERE JOB_NUMBER <> 0
>
> Several people have reported that by using a bogus where clause on
> the column that has the index, makes it use the index.

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.

Regards,

Mark