object_id vs exists performance comparison
Mar 16, 07i 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!