Tips to best use DB2 V10 and other performance topics

Date: 
Friday, 27 september, 2013 - 12:15 - 13:15
Speaker: 
Philippe Dubost

DB2 version 10 contains several new features which you can benefit from, such as Inline LOBs, including columns in an existing unique index, performance gains on Native SQL Procedures ... In this presentation, you will learn more about these features, and how to implement or configure them appropriately for better performance. The presentation contains 4 chapters, each of which is concluded by a tip that you can implement (almost) right-away:
Save CPU by including extra columns to an unique index
Is the length of your inline LOBs optimal ?
Impact of SELECT * versus SELECTing specific columns
Improve the response time of Native SQL procedures in DB2 v10

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2024

VODICE -  10th - 13th June 2024