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

SQL0437W reason code 3, anything to worry about?

P: n/a

While investigating deadlocks in an application I wrote a function to
check if there where any batchjobs running in parallell at the time of
the deadlocks. The check runs surprisingly fast, but If I narrow the
searchspace I start getting SQL0437W with reason code 3 "Optimizer cost
underflow". Statistics are up to date on the table. Is this something to
worry about, or can the warning be ignored?
/Lennart
Mar 22 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Lennart wrote:
While investigating deadlocks in an application I wrote a function to
check if there where any batchjobs running in parallell at the time of
the deadlocks. The check runs surprisingly fast, but If I narrow the
searchspace I start getting SQL0437W with reason code 3 "Optimizer cost
underflow". Statistics are up to date on the table. Is this something to
worry about, or can the warning be ignored?

Never mind, I rewrote it slightly and the warning disappeared
/Lennart

Mar 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.