Re: partitioned unique index
From: Mladen Gogala <no_at_email.here.invalid>
Date: Mon, 11 Oct 2010 16:46:18 +0000 (UTC)
Message-ID: <pan.2010.10.11.16.46.18_at_email.here.invalid>
On Mon, 11 Oct 2010 04:43:51 -0700, alex123 wrote:
Date: Mon, 11 Oct 2010 16:46:18 +0000 (UTC)
Message-ID: <pan.2010.10.11.16.46.18_at_email.here.invalid>
On Mon, 11 Oct 2010 04:43:51 -0700, alex123 wrote:
> 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?
You can create a global unique index or you can create a unique prefixed local index.
-- http://mgogala.byethost5.comReceived on Mon Oct 11 2010 - 11:46:18 CDT