If even one row has LOCKWAIT non NULL, then your second query also goes for 100% CPU utilization. Try it.
Only if you have hint ( Ordered ) as suggested by Jurij is coming out irrespective of LOCKWAIT being null or not.
|
Results 1 to 10 of 11
Thread: Simple query - taking longThreaded View
|
Click Here to Expand Forum to Full Width |