[:P] Yeah, I was just messin' with ya. The only change to the plan was the index name. All the other stats are almost identical. The execution...
Did you not read my big post? :) It was a scan, I got it to do a seek (which it is doing now, even on the new covering index), but I'm still...
Well, I applied a covering index on OtherInfoTable to be: ItemID, InfoTag, InfoValue, and it reduced logical reads down to around 75000, but it is...
Okay, so I am having a query issue that is causing us to have program exceptions from running too long, over a minute is some cases. The table...
Separate names with a comma.