| Subject | Re: [ib-support] Adding index does nothing to select disctinct |
|---|---|
| Author | Tomislav Avramovic |
| Post date | 2002-09-16T09:19:28Z |
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?
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?