Prev: Commit the applied FixPak??
Next: Help
From: Lennart on 22 Mar 2007 14:21

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
From: Lennart on 22 Mar 2007 16:11
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

 | 
Pages: 1
Prev: Commit the applied FixPak??
Next: Help