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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitioning Question (1 of several)

RE: Partitioning Question (1 of several)

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 23 Mar 2004 10:02:07 -0500
Message-ID: <003101c410e7$cf1adaf0$0704a8c0@development.perceptron.com>


Why is it "horrible"?
What's wrong with this quote from oracle docs?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan.gaffuri_at_cox.net Sent: Monday, March 22, 2004 5:42 PM
To: oracle-l_at_freelists.org
Subject: Re: Partitioning Question (1 of several)

was that right out of the oracle docs? That is horrible.

My understanding is that partitioning pruning = partition elimination. Say have a table with 3 partitions.

Based on your where clause Oracle will know in advance which partition(s) are needed for the sql statement and their by 'pruning' or eliminating the other partitions from being scanned.
>
> From: david wendelken <davewendelken_at_earthlink.net>
> Date: 2004/03/22 Mon PM 01:35:43 EST
> To: oracle-l_at_freelists.org
> Subject: Partitioning Question (1 of several)
>
>
> "Partition pruning dramatically reduces the amount of data retrieved
from disk and shortens the use of processing time, improving query performance and resource utilization. If you partition the index and table on different columns (with a global, partitioned index), partition pruning also eliminates index partitions even when the partitions of the underlying table cannot be eliminated."
>
> I not positive I understand the second sentence. Could someone give
an example?
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 23 2004 - 09:06:41 CST

Original text of this message

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