DB2 9 Provides a DB2 Performance Boost

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.

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

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