On Tuesday 20 July 2010 17:17:03 you wrote: > BuildFarmJob.status <> 1 > ^- this causes a table scan doesn't it? can we switch it to an IN list ?
Hmmm, I assumed that it would be fine with an index, but maybe not?
On Tuesday 20 July 2010 17:17:03 you wrote:
> BuildFarmJob.status <> 1
> ^- this causes a table scan doesn't it? can we switch it to an IN list ?
Hmmm, I assumed that it would be fine with an index, but maybe not?