Re: Local indexes

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/06/09
Message-ID: <39405601@news.iprimus.com.au>#1/1

<amerar_at_my-deja.com> wrote in message news:8hodad$283$1_at_nnrp1.deja.com...
>
>
> Hello,
>
> I have a question. I am about to partition a very large table. The
> table holds about 5 million records. This table also has a primary key.
> When you define a primary key on a table, it also creates an index.
> Can I make this index local so it is also partitioned?
>
> I am unsure because the index is 'automatically' created when you define
> the primary key constraint.........
>

Only if you haven't already created an index on the relevant key for your own purposes. I suggest you index the thing before defining the constraints, and then tell it which index to use when constraining. You can do what you like with indexes created by your own good self. HJR
> Please cc a copy to: amerar_at_ci.chi.il.us
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jun 09 2000 - 00:00:00 CDT