DWH : Index on Partition Key s
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 Oct 2009 23:01:00 +0800
Would there be any reason to create a single column index on the
PARTITION_KEY column (which is a VARCHAR2 representation of a date
--- I know, I know, bear with me !) ?
So, we have 24 PARTITION_KEY values for the 24 months that we are holding data.
Why have a single-column index on PARTITION_KEY ?
(no this isn't a trick question : I am really confused by this
design that I see having been implemented).
Hemant K Chitale
http://hemantoracledba.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
