Multi-column Range Partitioning

From: Sanjay Mishra <sanjay_mishra0_at_yahoo.com>
Date: Tue, 5 Aug 2008 12:04:10 -0700 (PDT)
Message-ID: <185328.68598.qm@web33802.mail.mud.yahoo.com>


Are you using multi-column range partitioning? If yes, I would like to know any known issues, restrictions and best practices on using multiple columns as the partitioning key. Please note that I am referring to multiple columns in the PARTITION BY RANGE clause, not the composite partitioning (subpartiitons)?
 

I have a situation where I could range partition by ORDER_DATE, or use multiple columns (ORDER_DATE, CUSTOMER_ID) in the range partitioning key. I am about ot start benchmarking our workload on both the designs. I will appreciate if you can share your experiences and example of scenarios where you really benefited by adding extra columns to the partitioning key.
 

Thanks.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 05 2008 - 14:04:10 CDT

Original text of this message