Search code examples
cachingsybasedatabase-performance

What is the difference between DBCC cachedataremove and sp_unbindcache?

I would like to know the difference between DBCC cachedataremove and sp_unbindcache. because in my project i got permissions for unbindingcache but not to execute DBCC cachedataremove. I was assuming that they did pretty much the same thing.

SYBASE ASE 15.7

Solution

  • sp_unbindcache is used to unbind and object from a user-defined cache whereas dbcc cachedataremove is use to remove an object from default data cache.

    You cannot bind objects to default data cache explicitly only to user-defined caches.