"csmba" <csmba@nowhere.com> wrote in message
news:efIepTgfGHA.4828@TK2MSFTNGP05.phx.gbl...
> Hi all. I got the next very simple and strange problem. When running the
> following 2 slqs, one runs very fast, and one very slow. I looked at my
> indexes time and time again, and cannot figure out why. The table has
> about 8 million rows.
>
> Very fast:
>
> Select top 1 keyA from tableA where fieldB = 0 and keyA=keyA order by
> fieldC
>
> Very slow:
>
> Select top 1 keyA from tableA where fieldB = 0 order by fieldC
>
> Properties:
>
> keyA: integer unique key of tableA (clustered index)
>
> fieldB: integer (non-clustered index)
>
> fieldC: integer (non-clustered index)
>
> any ideas?
>
>

> Hi all. I got the next very simple and strange problem. When running the
> following 2 slqs, one runs very fast, and one very slow. I looked at my
> indexes time and time again, and cannot figure out why. The table has
> about 8 million rows.
>
> Very fast:
>
> Select top 1 keyA from tableA where fieldB = 0 and keyA=keyA order by
> fieldC
>
> Very slow:
>
> Select top 1 keyA from tableA where fieldB = 0 order by fieldC
>
> Properties:
>
> keyA: integer unique key of tableA (clustered index)
>
> fieldB: integer (non-clustered index)
>
> fieldC: integer (non-clustered index)