Expect more list prefetch – a Db2 12 greatest hit with John Campbell

(John Campbell, Terry Purcell, and Paul McWilliams) In Db2 12, you can expect to see increased use of list prefetch access, and possibly more use of hybrid join access paths by design, except where Db2 previously chose a sort-avoidance access plan, such as for statements that use SQL pagination.

Register to Read