object_id vs exists performance comparison

Mar 16, 07

i previously blogged about using the object_id function in a drop statement instead of the usual way. i wondered how it did performance wise. it may be prettier, but is it faster? slower? the short answer is it appears to be faster to use the function than the default drops.

you can pick another proc or table or whatever object you want for analysis. the results were the same for me. enjoy!