Subject Re: [ib-support] Adding index does nothing to select disctinct
Author Tomislav Avramovic
Try this
SELECT JOB_NUMBER FROM SAWMEMEBRS
GROUP BY JOB_NUMBER

GROUP BY will use index on (JOB_NUMBER), but some times you have better
performance with non indexed read.
Any improvments?