DB2 V10.1 Query performance enhancements

A number of performance improvements have been included in DB2 Version 10.1 to improve the speed of many queries. These improvements are automatic; there are no configuration settings or changes to the SQL statements required.

David Sky (sky@ca.ibm.com), Senior Technical Writer, IBM China

Author photoDavid Sky is a senior technical writer with the DB2 for Linux, UNIX, and Windows product team at the IBM Canada Lab in Markham, Ontario. He has worked on a wide range of DB2 documentation, and is currently responsible for several content areas in the DB2 Information Center, including SQL query performance. He holds a Bachelor degree in Artificial Intelligence from the department of Computer Science at the University of Toronto. He is currently collaborating with the DB2 best practices development team on a range of subjects.

30 April 2012

With each release of DB2®, IBM® continues to focus on maintaining the excellent SQL query optimization and performance that customers expect. The DB2 V10.1 for Linux®, UNIX®, and Windows® release is no different, with the addition of the following improvements.

In this article

  • Automatic performance improvements for common types of SQL queries including star schema based queries.
  • New features that customers can use to further increase the speed of their SQL queries.
  • New features that customers can use to reduce the complexity of tuning certain types of SQL queries.
  • Enhanced memory sharing on large POWER7® systems running AIX®.

This paper describes these additions.


Article in PDF formatDB2V10_Query_Perf_Enhancements_0412.pdf587KB


Zone=Information Management
SummaryTitle=DB2 V10.1 Query performance enhancements