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

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie : getting rid of IN clause

Re: newbie : getting rid of IN clause

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 03 Aug 2006 08:09:30 +0200
Message-ID: <ko43d2hgub0s9sivd246svknnmeml7imbu@4ax.com>


On 2 Aug 2006 15:07:46 -0700, "dn.perl_at_gmail.com" <dn.perl_at_gmail.com> wrote:

>Besides I mostly use TOAD and apparently it uses some other approach to
>'explain plan'. Still, the exercise has been useful to me.

If Toad has been set up correctly, hitting Ctrl-e generates the explain for the current statement and dumps the results in a separate screen below the statement.

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Aug 03 2006 - 01:09:30 CDT

Original text of this message

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