Re: Explain Plan question...

Sean wrote:
>
> Thanks Sybrand,
> I went to the technet site to look for the Oracle App Dev Guide as
> you recommended. I think I found it, but when looking through the
> contents, I could not find anything on explain plan. It mostly
> referred to different cartridges and programming to them on an Apps
> server.
>
> If you have any books you recommend on EXPLAIN PLAN, I'd enjoy hearing
> them.
>
> Thanks again,
> Sean
>
> In article <954398302.22005.0.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > The EXPLAIN PLAN output is discussed in the Oracle Application
> Developers
> > Guide and in many performance tuning books. Basically you should read
> it
> > inside out, so the most-indented steps are executed first.
> > One thing obvious from the plan, is you don't give your primary key
> > constraints a proper name.
> > A range scan is a scan for a range of keys (so 1 or more), an unique
> scan is
> > a scan for one particular key.
> >
> > Hth,
> > Sybrand Bakker, Oracle DBA
> >
> > Sean <dolans_at_my-deja.com> wrote in message
> > news:8budha$e1e$1_at_nnrp1.deja.com...
> > > I am using the TOAD software and just found the explain plan item.
> > > Looks great, but I am having trouble understanding how to interpret
> the
> > > results. Is there any documentation or websites that can help point
> > > this out?
> > >
> > > I am curious what I should be looking for. And is a RANGE SCAN
> better
> > > or worse than a UNIQUE SCAN?
> > >
> > > Thanks,
> > > Sean
> > >
> > > PS I'll put the output below in case anyone would like to comment.
> > > Thanks again.
> > >
> > > SELECT STATEMENT Optimizer=CHOOSE
> > > SORT (ORDER BY)
> > > NESTED LOOPS
> > > NESTED LOOPS
> > > NESTED LOOPS
> > > NESTED LOOPS
> > > NESTED LOOPS
> > > TABLE ACCESS (BY INDEX ROWID) OF KNOW
> > > INDEX (RANGE SCAN) OF XIF180KNOW (NON-UNIQUE)
> > > TABLE ACCESS (BY INDEX ROWID) OF STAT_KNOW_REC
> > > INDEX (UNIQUE SCAN) OF SYS_C006796 (UNIQUE)
> > > INDEX (UNIQUE SCAN) OF SYS_C006685 (UNIQUE)
> > > TABLE ACCESS (BY INDEX ROWID) OF SYSTEM_GRP_USER
> > > INDEX (RANGE SCAN) OF XIF127SYSTEM_GRP_USER (NON-UNIQUE)
> > > INDEX (UNIQUE SCAN) OF SYS_C006629 (UNIQUE)
> > > INDEX (UNIQUE SCAN) OF SYS_C006719 (UNIQUE)
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Search amazon for books by "Guy Harrison" and also check the "Server [Quoted] Tuning" book on technet.oracle.com

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse