Topic: Cross Platform DB2 for z/OS & LUW
EXPLAIN is one of the most valuable tools for performance analysis. Like the DB2 internal SQL optimization it's also based on statistics. For new DB2 applications and those with changing data characteristics, however, there is a lack of appropriate statistics. The presentation desribes an approach how to create them synthetically for DB2 for z/OS (without the need of complex data generation) using extended data models.
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.