slowdown of query with <>0 parameter in summed number field

[hedgracer]

have a query that has a <>0 in a summed number field. The query runs
extremely slow (30+ seconds) when this parameter is in this field. If
I eliminate this parameter the query runs in milliseconds. This is a
query on a linked odbc sql server 2005 table. Any thoughts on the
theory of why this happens? Thanks.

dave

[Tom van Stiphout]

Re: slowdown of query with &lt;&gt;0 parameter in summed number field

On Tue, 12 Feb 2008 11:36:39 -0800 (PST), hedgracer
<d.christman@sb cglobal.netwrot e:

My thoughts on the theory is that the column is not indexed.
-Tom.

have a query that has a <>0 in a summed number field. The query runs
>extremely slow (30+ seconds) when this parameter is in this field. If
>I eliminate this parameter the query runs in milliseconds. This is a
>query on a linked odbc sql server 2005 table. Any thoughts on the
>theory of why this happens? Thanks.
>
>dave