Re: Should one include partitioning key column as first column of non-unique local index
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 16 Aug 2011 15:42:26 +0200
Message-ID: <9avaegFvgnU1_at_mid.individual.net>
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.
Date: Tue, 16 Aug 2011 15:42:26 +0200
Message-ID: <9avaegFvgnU1_at_mid.individual.net>
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?
Cheers
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Tue Aug 16 2011 - 08:42:26 CDT