Monday, June 26, 2006

I really need a vacation

Especially when I see developers coming up with SQL like the following snippet from an autotrace. I just want to give up and go home.


Elapsed: 00:00:02.23
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE ( Cost=60278 Card=2488086119
Bytes=25341157122015 )
1 0 HASH JOIN (OUTER) (Cost=60278 Card=2488086119 Bytes=253411
57122015)
2 1 HASH JOIN (OUTER) (Cost=512 Card=435925 Bytes=4422895050
)
3 2 HASH JOIN (OUTER) (Cost=172 Card=1690 Bytes=17080830)
4 3 HASH JOIN (OUTER) (Cost=104 Card=13 Bytes=130884)

No comments: