Articles & Content

Archives

D11 - Dealing With Complex Warehouse Query Performance

Topic: DB2 for LUW

Subtopic: 2013



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.