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
<div>Jay,</div> <div> </div> <div>Just a thought. You might prepare an equivalent SQL statement, something like select count(*) from table where . . . .</div> <div>That might help you debug the issue as a SQL statement and figure out why your index isn't being used.</div> <div> </div> <div>Dennis Williams</div>