News, views, and items of interest on IBM's Db2 database management system and mainframes.
Wednesday, August 12, 2015
Influencing the DB2 Optimizer: Part 5 - Changing DB2 Catalog Statistics
›
When the standard methods of influencing DB2’s access path selection -- as discussed in the first 4 parts of this series ( 1 , 2 , 3 , ...
2 comments:
Tuesday, July 21, 2015
Influencing the DB2 Optimizer: Part 4 - OPTIMIZE FOR n ROWS
›
In the first installments of this series of posts on ways to influence the DB2 optimizer we looked at standard methods like RUNSTATS and SQ...
Thursday, July 16, 2015
Influencing the DB2 Optimizer: Part 3 - Tweaking SQL Statements
›
In Part 2 of this series we took a look at standard methods of influencing the DB2 optimizer, essentially boiling down to running RUNSTATS,...
Wednesday, July 08, 2015
Influencing the DB2 Optimizer: Part 2 - Standard Methods
›
Last week, in Part 1 of this series, we introduced the concept and the 5 high-level methods of influencing the DB2 optimizer's access ...
Wednesday, July 01, 2015
Influencing the DB2 Optimizer: Part 1
›
Today is July 1, 2015 - mid way through the year and the beginning a fresh, new month. With that in mind, I'm kicking off a new series o...
1 comment:
‹
›
Home
View web version