The Db2 Portal Blog

News, views, and items of interest on IBM's Db2 database management system and mainframes.

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:
Monday, June 22, 2015

The DBMS Market Circa 2015

›
Today's blog post is to call attention to a series of articles and product overviews I have been writing for the TechTarget SearchDataMa...
‹
›
Home
View web version

About Me

My photo
Craig S. Mullins
Sugar Land, Texas, United States
Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for The Database Site.

Craig has been named by IBM as a Gold Consultant and an IBM Champion for Analytics. He has been named as one of the Top 200 Thought Leaders in Big Data and Analytics by AnalyticsWeek magazine.

Craig has over three decades of experience in all facets of database systems development and has worked with Db2 since V1. You may know Craig from his popular books: Db2 Developer's Guide (covering IBM's mainframe RDBMS)... A Guide to Db2 Performance for Application Developers (how to write efficient Db2 programs) and... Database Administration: The Complete Guide to DBA Practices and Procedures (a guide to heterogenous DBA).
View my complete profile
Powered by Blogger.