Grokbase › Groups › Oracle › oracle-l › March 2004
FAQ
"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.

Search Discussions

  • Bobak, Mark at Mar 22, 2004 at 1:43 pm ⇧
    Well, I'm certainly not the partitioning expert, but I think what it's saying is that if the index is partitioned differently from the table, then for index access paths, they are eligible for partition pruning, even if said pruning is not compatible with the table's partition scheme. This makes sense, since the index is global and partitioned, partition pruning can happen at index access time, then whatever index access operation is dictated, then the requisite table access by rowid to get any required data from the table. Since it's a global index, the rowids in the index entries from the index partition that was utilized, may point to any table rows in any table partition.

    -Mark

    -----Original Message-----
    From: david wendelken
    Sent: Monday, March 22, 2004 1:36 PM
    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
  • Ryan.gaffuri_at_cox.net at Mar 22, 2004 at 5:25 pm ⇧
    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
    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
    -----------------------------------------------------------------
  • Igor Neyman at Mar 23, 2004 at 9:06 am ⇧
    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
    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
    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
    -----------------------------------------------------------------

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 22, '04 at 12:37p
activeMar 23, '04 at 9:06a
posts4
users4
websiteoracle.com

4 users in discussion

Igor Neyman: 1 post Bobak, Mark: 1 post David wendelken: 1 post Ryan.gaffuri_at_cox.net: 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase