Archive for March, 2012

Import a subset of table columns using Oracle Data Pump

Mar 06 2012

Importing data is most efficient when you load only the columns you need into the target database. This becomes apparent when importing unnecessary LOB columns, which can slow down an import significantly. One method of limiting which columns to import is to first only export the columns you need. You can create a temporary table […]

Generating an Explain Plan in DB2 9.7 for LUW

Mar 04 2012

Similar to Oracle’s EXPLAIN PLAN statement and MySQL’s EXPLAIN statement, DB2 provides an EXPLAIN PLAN statement which generates information about the access plan chosen for the specified statement. The information is then placed into explain tables for reference. However, there are times when you simply want to see the explain plan displayed in a hierarchical format with […]