DWH : Index on Partition Key s

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 30 Oct 2009 23:01:00 +0800
Message-Id: <200910301500.n9UF0xla016400_at_smtp44.singnet.com.sg>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 30 2009 - 10:01:00 CDT

This message: [ Message body ]
Next message: Jeremiah Wilton: "Re: Anyone know of an Oracle suitable AMI in eu-west?"
Previous message: Alex Fatkulin: "Re: Migrating to a new OEM Grid Control box"
Next in thread: Stephane Faroult: "Re: DWH : Index on Partition Key s"
Reply: Stephane Faroult: "Re: DWH : Index on Partition Key s"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message