Blogs

Utilities for Developers

Harness the magic of REORG and LOAD

October 15, 2011 | by Bonnie Baker
Harness the magic of REORG and LOAD

PLANs + COLLECTIONs + VERSIONs + PACKAGEs + DBRMs = Confusion

Revisiting program preparation on DB2

July 15, 2011 | by Bonnie Baker
Revisiting program preparation on DB2

New ORDER BY Information: Part 2

The impact of using the RANDOM index option on ORDER BY sort avoidance

April 15, 2011 | by Bonnie Baker
The impact of using the RANDOM index option on ORDER BY sort avoidance

New ORDER BY Information: Part 1

Avoiding sorts with data-partitioned secondary indexes

January 15, 2011 | by Bonnie Baker
Avoiding sorts with data-partitioned secondary indexes

Does the Order of SQL Predicates Matter?

Rearranging WHERE clause predicates may be an exercise in futility

October 15, 2010 | by Bonnie Baker
Rearranging WHERE clause predicates may be an exercise in futility

Reducing Conversations with DB2 for z/OS: Part 3

Different ways of thinking about ordinary things

July 21, 2010 | by Bonnie Baker
Different ways of thinking about ordinary things

Reducing Conversations with DB2 for z/OS: Part 2

More tried-and-true basics and a few new bells and whistles

April 21, 2010 | by Bonnie Baker
More tried-and-true basics and a few new bells and whistles

Reducing Conversations with DB2 for z/OS: Part 1

As Prem Mehra said, “There is no better-performing SQL than the SQL that is not executed.”

September 15, 2009 | by Bonnie Baker
As Prem Mehra said, “There is no better-performing SQL than the SQL that is not executed.”