| Subject | Re: [ib-support] Adding index does nothing to select disctinct |
|---|---|
| Author | Tomislav Avramovic |
| Post date | 2002-09-16T10:11:03Z |
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 (low selectiv index, a lot of duplicate
values).
Any improvments?
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 (low selectiv index, a lot of duplicate
values).
Any improvments?