On 7/10/2010 9:35 AM, sqlsvr wrote:

> Nevermind fixed it. I just checked the index selectivity and it's very low selectivity. When I did the count, I thought the filter used was the primary key (which has a high selectivity) but used a foreign key instead of the primary key.
>

You're welcome.