Benefits of sub partitioning by hash

From: Rob Dempsey <Rob.Dempsey_at_5one.co.uk>
Date: Wed, 13 May 2009 11:16:16 +0100
Message-ID: <C9BAD64468971546A037D29F0031F02701AA6269_at_ENET6.5one.co.uk>



Hi  

Oracle Version 10g2  

We have a typical sales items type table that is partitioned by date and has local bitmap indexes on product code and site code.  

I was wondering what are the benefits of sub partitioned by hash on either the customer number or the order number?  

Typical queries just sum up quantities sales over a give date range. However we do have some queries which will self-join the table i.e. For a given order what other products are in that order  

We do use parallel hints in the queries as well  

Any insight will be much appreciated  

Rob

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 13 2009 - 05:16:16 CDT

Original text of this message