Access Plan


An alternate way to analyze the query slowdown problem, is by going through the explain snapshot. An explain snapshot is compressed information that is collected when an SQL statement is explained. It contains



Run the following steps on the DB2 CLP window to view the explain snapshot :