Re: Should one include partitioning key column as first column of non-unique local index

From: Robert Klemme <>
Date: Tue, 16 Aug 2011 15:42:26 +0200
Message-ID: <>

On 15.08.2011 16:33, Robert Klemme wrote:
> On 15.08.2011 09:51, vsevolod afanassiev wrote:
>> I think Oracle doesn't allow compression of partitioned indexes
> I don't know about 9.* but I am sure that 10 does.

PS: Compression works in that version with a global index as well.

PPS: Also I wouldn't know any reason which prohibits key compression for indexes on partitioned tables.

Did I miss something?



remember.guy do |as, often| as.you_can - without end
Received on Tue Aug 16 2011 - 08:42:26 CDT

Original text of this message