Re: partitioned unique index
From: joel garry <joel-garry_at_home.com>
Date: Tue, 12 Oct 2010 14:32:11 -0700 (PDT)
Message-ID: <d6c516ac-ecb0-4135-b93f-466ff7192a48_at_n41g2000prb.googlegroups.com>
On Oct 12, 12:16 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> "alex123" <michalw..._at_poczta.fm> wrote in message
>
> news:02752f68-e0c6-4d77-9c36-a87942d29934_at_g10g2000vbc.googlegroups.com...
>
> > Hi,
>
> > I have a table with is partitioned by value by one of column A. It is
> > possible to create primary key on another column B which index will be
> > partitioned like table?
>
> No,
>
> If you want a local index to support a primary key or unique constraint
> the partitioning column(s) have to be a subset of the primary key / unique
> column(s)
Date: Tue, 12 Oct 2010 14:32:11 -0700 (PDT)
Message-ID: <d6c516ac-ecb0-4135-b93f-466ff7192a48_at_n41g2000prb.googlegroups.com>
On Oct 12, 12:16 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> "alex123" <michalw..._at_poczta.fm> wrote in message
>
> news:02752f68-e0c6-4d77-9c36-a87942d29934_at_g10g2000vbc.googlegroups.com...
>
> > Hi,
>
> > I have a table with is partitioned by value by one of column A. It is
> > possible to create primary key on another column B which index will be
> > partitioned like table?
>
> No,
>
> If you want a local index to support a primary key or unique constraint
> the partitioning column(s) have to be a subset of the primary key / unique
> column(s)
Of course I have no idea what I'm talking about, but wondering if this is a use for cube-organized materialized views. I'm guessing that since minimax operators are a type of aggregator, there might be a way to effectively repartition with the mview: http://www.rittmanmead.com/files/COMV_PAPER.pdf
jg
-- _at_home.com is bogus. http://threatpost.com/en_us/blogs/twitter-closes-web-hole-after-attack-hits-500000-092110Received on Tue Oct 12 2010 - 16:32:11 CDT