PLAN_TABLE contents

SQL Performance Analyzer handles a PLAN_TABLE differently depending upon whether a PLAN_TABLE already exists or needs to be created.

If you do not already have a PLAN_TABLE table, one will be created for you. The newly created PLAN_TABLE will be located in the default database, unless a row giving the names of the database and table space was inserted into the EEEWORK table.

The content of the PLAN_TABLE table is dependent on the Db2 version you are using. If you already have a PLAN_TABLE table, SQL Performance Analyzer compares the Db2 level and the columns available in the PLAN_TABLE, and automatically adds any missing columns.