By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,600 Members | 1,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,600 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.