Partition PRUNING
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Partition PRUNING

  1. #1
    Join Date
    Feb 2001
    Posts
    82
    can anybody explain me what is partition pruning?????

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    I would suggest that it is to do with dropping unused partitions in a table. Before doing this though, you should be careful to identify whether or not the indexes you have on the partitions are local or global indexes. If the indexes are global to the partitioned table, after the partition is dropped, the associated table index will marked 'unusable', until it is rebuilt.

    Anyone else with thoughts on this?

    Cheers
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Partition pruning is the method that the optimizer uses to to exclude partitions from the results of a query. See http://otn.oracle.com/docs/products/...part.htm#98260 for details.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Talking Partition pruning

    Hi,

    Partition pruning is the abliliy of the CBO to only use the partition which holds the data being queried.

    Say you partitioned a table into q1_2001, q2_2001 and q3_2001 and you are interested in data of february 2001, only partition q1_2001 data will be read.

    The q2_2001 and q3_2001 partititions will be pruned.

    Greetings tycho

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width