|
Posted by Greg D. Moore \(Strider\) on 10/01/49 11:22
"louis" <louisducnguyen@gmail.com> wrote in message
news:1122398417.122977.34990@f14g2000cwb.googlegroups.com...
> My guess is that the query is doing a bookmark lookup. When the server
> isn't busy, MSSQL is trying to be helpful by issuing read-aheads
> against the clustered index. I would try creating a covering index, so
> MSSQL will only have to read one index.
Thanks for the guess, but even a covering index doesn't seem to help.
>
Navigation:
[Reply to this message]
|