Partition Question

From: <amerar_at_my-deja.com>
Date: 2000/05/31
Message-ID: <8h3q91$mgr$1@nnrp1.deja.com>#1/1

Hello,

I'm sort of new to the partition thing, so perhaps someone can help me.

I am creating a partitioned table. The partition key will be the same between the tables and indexes, so I will use local indexes. Now, when I create a primary key, which automatically creates a unique index, is that partitioned? How do I make the primary key partitioned? I'm a bit unsre of the syntax and the concept. I mean, a primary key generates a unique index, so, should you not also parition that index????

It happens that the partition key is the same as the first 2 columns of the primary key.....so:

Table Partition Key: FIELDA, FIELDB
Primary Key: FIELDA, FIELDB, FIELDC

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 Wed May 31 2000 - 00:00:00 CDT