Archive for December, 2008

18 Dec

Taking Advantage of Relational Technology Part 2

Avoid Inappropriate Tablespace Scans
There are many DB2 access paths available. The most expensive of these is a tablespace scan because it causes DB2 to scan all the entries of a table to retrieve the rows desired by the application.  Within most of the system and application performance reviews done at one recent client’s review, there [...]

10 Dec

Taking Advantage of Relational Technology

Last time we looked at the application design of a major DB2 system. Now, let’s delve a little further and look at the SQL used in these applications.
Taking Advantage of Relational Technology
During reviews of various client systems, analyzing the SQL used is very helpful for understanding how sophisticated the shop and system are at leveraging [...]

© 2010 Dave Beulke

Designed by NET-TEC Webspace -- Made free by Einladungskarten | Wintergarten | Ratenkredit
SEO Powered by Platinum SEO from Techblissonline