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.
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504