As it is selecting 20 million records, its obvious that it effects the performance of other transactions on the server as the tempdb will be heavily loaded.

1. Make sure...

Just curious to know, in what kind of situation do we need to know the existence of an object in a db??

Thanks,

Kalyan