Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
EXPLAIN is a bind parameter. While binding the application plan you might give the option EXPLAIN(YES). Default is EXPLAIN(NO).
If you give YES it would give the explanation about the queries in the DBRM into a separate table called PLAN_TABLE. The user binding the PLAN needs to have their own table. Later one can query the PLAN table to find out the access paths.
How a particular query is executing..? Is it going for INDEX SCAN or TABLESPACE scan. Is index used effectively or not and much more. Over all this is a huge concept. This comes into picture while during the performance tuning for the applications. You can find much more information in the manual.
If you bind the plan with EXPLAIN(YES) and if there is no explain table existing under your ownership then it would through you the -ve error code mostlikely -219 I guess. Hope this helps you..!! Thanks