Influencing the DB2 Optimizer: Part 4 – OPTIMIZE FOR n ROWS

(Craig S. Mullins) In the first installments of this series of posts on ways to influence the DB2 optimizer we looked at standard methods like RUNSTATS and SQL tweaking techniques. Today, we will look at yet another method of influencing access path selection: specifying the OPTIMIZE FOR n ROWS for

Read More - Register for Free Membership