Binding and unbinding objects may have an impact on performance. When you bind or unbind a table or an index:
The object’s pages are flushed from the cache.
The object must be locked to perform the binding.
All query plans for procedures and triggers must be recompiled.
