Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to explain plan to table other than plan_table?

Re: how to explain plan to table other than plan_table?

From: Ed Prochak <edprochak_at_gmail.com>
Date: 30 Aug 2006 13:38:38 -0700
Message-ID: <1156970318.716587.180660@e3g2000cwe.googlegroups.com>

Ben wrote:
> oracle ent ed, 9.2.0.5, dmts, compatible = 8.1.0 AIX5L
>
> How can you use explain plan with a plan table that is named something
> other than plan_table?

why would you want to put the plan somewhere else?

But if you do, it is an option in the command. Have you looked at the manual yet?

HTH,
  ed Received on Wed Aug 30 2006 - 15:38:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US