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
Lennart - 22 Mar 2007 21:11 GMT
> 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