Here is a good link on Explain plans and on displaying them.

http://optimizermagic.blogspot.com/2008/02/displaying-and-reading-execution-plans.html

I was reading this today and thought it was interesting.

Karen explains why having min and max in the same query impact performance and how to tackle the same.

Recently I was working with a few DB2 UDB 9.5 tables and discovered that decfloat datatype columns were not recognized even if I had checked the option to recognize unsupported datatypes as varchar.

I mailed someone who interacts closely with the product group in SAP - Business Objects.

Continue Reading »