Articles & Content


D11 - Dealing With Complex Warehouse Query Performance

Topic: 2013 NA

Subtopic: DB2 for LUW

Complex queries are very common in Data Warehouses. These could be machine generated or written by very smart application programmers. These queries may involve very large tables and could be very sensitive to the access plans chosen. The complexity naturally makes it difficult to optimize. This presentation looks at best practices with writing and tuning queries

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.