Partitioning opinion
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2004 13:02:17 -0400
Hi,
We have a table having 14 columns and contain historical data and we are
planning to implement partitioning so that we will keep only 12 months
data online and purge the old partition every month. We will be using
Range partitioning on Date column name Interv and have primary key on
(id,Interv). Data is never updated and only deleted for archiving that
we are planning to do as drop partition so for most of the time only
inserts will go against this table and few Selects. For performance of
select we have to add 2 more non-unique global indexes. So the schema
will look like:
Primary key index on (id,Interv)
Does non-prefix local indexes be Ok or we should change the order of PK
to (interv,id) to have prefix local index?
Non-unique index on 3 columns
Non-unique index on 3 columns
Should we partition these global non-unique indexes or it does not
matter since partitions will not be used by optimizer for pruning?
Thanks
--Harvinder
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
