469,576 Members | 1,650 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,576 developers. It's quick & easy.

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

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
Feb 12 '08 #1
1 1347
On Tue, 12 Feb 2008 11:36:39 -0800 (PST), hedgracer
<d.*********@sbcglobal.netwrote:

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
Feb 13 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by The Plankmeister | last post: by
3 posts views Thread by cassandra.flowers | last post: by
3 posts views Thread by Uwe | last post: by
reply views Thread by HomerS007 | last post: by
1 post views Thread by codexxx | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.