News, views, and items of interest on IBM's Db2 database management system and mainframes.
Tuesday, April 28, 2015
Controlling Mainframe Software Costs
›
Although this blog usually focuses on DB2 issues, I sometimes use it to focus on other IT issues, usually mainframe-related. The primary pur...
3 comments:
Tuesday, April 21, 2015
SQL Performance Basics: Part 7, Embed the SQL Directly Into Your Programs
›
You may recall that this is a subject I've written about before, but I think it is important enough to warrant covering briefly in this ...
Thursday, April 16, 2015
SQL Performance Basics: Part 6, Code Relationally... or Avoid the Flat-File Mentality
›
A nother pervasive problem permeating the DB2 development community -- and indeed for most relational DBMSes -- is the “flat file” developm...
Saturday, April 11, 2015
SQL Performance Basics: Part 5, Avoid Sorting
›
Sorting is a very costly operation that you should strive to avoid if at all possible. Indexes are very useful for this purpose. DB2 can ch...
Tuesday, April 07, 2015
SQL Performance Basics: Part 4, The Order of Predicates
›
Did you know that the order in which you code your predicates can have an impact on query performance? It is usually a minimal impact, but...
‹
›
Home
View web version
