Prefetch on, prefetch off, prefetch on, prefetch off, prefetch….

(Willie Favero) Sequential prefetch has been a part of DB2 since Version 1.2. In fact, it’s hard to imagine getting along without. Even when the “R” in the plan table column ACCESSTYPE gets misinterpreted sometimes as a bad thing, if you’ve been around DB2 long enough you learn that an access using

Read More - Register for Free Membership