Run the EXPLAn query pointing to existing PLAN_TABLE

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Hi,

When I run the following SQL statement

EXPLAIN PLAN SET QUERYNO = 100 FOR
SELECT * FROM TABLE;

it says

MYID.PLAN_TABLE doesn't exist.

The creator for PLAN_TABLE is something WGH.

How can I run the EXPLAn query pointing to existing PLAN_TABLE?

vini_srcna · Posted: Fri Mar 23, 2007 4:44 pm

Yes, you need to be the owner of a plan table to explain the access strategies.

Check if you have the required privieges to use the existing plan table.

SET CURRENT SQLID = 'WGH';
EXPLAIN PLAN SET QUERYNO = 100 FOR
SELECT * FROM TABLE;