Jay,

 

Just a thought. You might prepare an equivalent SQL statement, something like select count(*) from table where . . . .

That might help you debug the issue as a SQL statement and figure out why your index isn't being used.

 

Dennis Williams