DB2 9 Provides a DB2 Performance Boost

By Dave Beulke, on September 27th, 2010

DB2 9 Provides a DB2 Performance Boost

2007 DB2 Magazine provides specific examples of DB2 SELECT, DB2 FETCH and more to show how DB2 9 for DB2 zos can improve DB2 performance.

Comments are closed   DB2 General Information-   , , , ,  

Performance features in DB2 V9 for z/OS – Part 9

By Dave Beulke, on September 8th, 2009

ORDER BY and FETCH FIRST n ROWS in a Sub-Select
Another one of the new enhancements, ORDER BY and FETCH FIRST n ROWS in sub-select and full-select, is especially great for web and Java application programmers. You may be surprised because your programmers have been using ORDER BY and FETCH FIRST n ROWS for some time, but in DB2 Version 9 for z/OS . . . → Read More: Performance features in DB2 V9 for z/OS — Part 9

Leave a comment   DB2 for z/OS   , , , ,