Why is it "horrible"?
What's wrong with this quote from oracle docs?
Igor Neyman, OCP DBA
On Behalf Of ryan.gaffuri_at_cox.net
Sent: Monday, March 22, 2004 5:42 PM
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
Date: 2004/03/22 Mon PM 01:35:43 EST
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."
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.