I've found another set of indices which gives good performance with both
queries. I'm now looking forward to keeping a careful eye on them to
make sure things don't change for the worse as I optimise other things!
--
Tim Ward
>The query is
>
>select [some columns]
> from MYTABLE
> where FIELDONE= 2 and FIELDTWO< 2
> order by [some columns]
>
>Most of the time most records have FIELDONE = 2 and FIELDTWO = 2, so this
>query is looking
>for what are normally a small number of exceptions, and one of my objecti
The query is
select [some columns]
from MYTABLE
where FIELDONE= 2 and FIELDTWO< 2
order by [some columns]
Most of the time most records have FIELDONE = 2 and FIELDTWO = 2, so
this query is looking for what are normally a small number of
exceptions, and one of my objectives is to