Off to the races: Running Runstats by Howard Goldberg One of the most common maintenance activities performed on a Db2 LUW database is running Runstats on tables and indexes. Accurate database statistics are vital for the Db2 Optimizer to produce the most optimal plans. The optimizer...
2 Comments - no search term matches found in comments.
Scaling DB2 BLU Horizontally with DB2 11.1 By: Joe Geller & Ian Bjorhovde The DB2 BLU Engine, which introduced column-organized tables, was released with DB2 10.5 and greatly enhanced in 10.5 Fixpack 4. Even though the performance of analytical queries showed tremendous...