Re: Partition Elimination

The docs actually do a good job of showing what the explain plan will look like for a partition elimination.

Look at the 'Explan Plan' chapter of 'Designing and Tuning for Performance'

Are you using ?/rdbms/admin/utlxplp.sql to examine your explain plan?

Jared

On Thursday 31 May 2001 09:00, dave.leach_at_paymaster.co.uk wrote:
> Hi All,
>
> Can anyone help me with this.
>
> I have range partitioned a table (no indexes) and then computed statistics.
> I have now queried the table using the partition key as the only criteria
> in the where clause. Why does Oracle still do a full table scan, why is it
> not clever enough to only scan the partition(s) effected by the where
> condition?.
>
> The Oracle documentation gives a good insight into partitioning but does
> not go into detail about when partition elimination will be performed and
> what the explain plan would look like when this occurs. If anyone can
> point me to a section of the documentation that covers this I would be
> grateful.
>
> Many Thanks,
>
> Dave Leach
>
>
> **********************************************************************
> The above information is confidential to the addressee and may be
> privileged. Unauthorised access and use is prohibited.
>
> Internet communications are not secure and therefore this Company does not
> accept legal responsibility for the contents of this message.
>
> If you are not the intended recipient, any disclosure, copying,
> distribution or any action taken or omitted to be taken in reliance on it,
> is prohibited and may be unlawful.
>
> Hogg Robinson PLC
> Registered Office: Abbey House, 282 Farnborough Road,
> Farnborough,
> Hampshire GU14 7NJ
> Registered in England and Wales No 3249700
>
> **********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).