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
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-lReceived on Wed May 13 2009 - 05:16:16 CDT