Cache binding effects on memory and query plans  Locking to perform bindings

Chapter 4: Configuring Data Caches

Flushing pages from cache

When you bind an object or database to a cache, the object’s pages that are already in memory are removed from the source cache. The next time the pages are needed by a query, they are read into the new cache. Similarly, when you unbind objects, the pages in cache are removed from the user-configured cache and read into the default cache the next time they are needed by a query.





Copyright © 2005. Sybase Inc. All rights reserved. Locking to perform bindings

View this book as PDF