Harness the magic of REORG and LOAD
Bonnie Baker specializes in teaching onsite classes and consulting for corporations, agencies, and DB2 user groups. She is an IBM DB2 Gold Consultant, an IBM Information Champion, a five-time winner of the IDUG Best Speaker award, and a member of the IDUG Speakers’ Hall of Fame. She is best known for her ability to demystify complex concepts through analogies and simplify difficult topics.
Harness the magic of REORG and LOAD
Revisiting program preparation on DB2
The impact of using the RANDOM index option on ORDER BY sort avoidance
Avoiding sorts with data-partitioned secondary indexes
Rearranging WHERE clause predicates may be an exercise in futility
Different ways of thinking about ordinary things
More tried-and-true basics and a few new bells and whistles
As Prem Mehra said, “There is no better-performing SQL than the SQL that is not executed.”