table partitioning doubt

From: zmaker <>
Date: Wed, 14 May 2008 01:12:43 -0700 (PDT)
Message-ID: <>

I have a simple/stupid question about partitioning.

I have created an empty partitioned (by range) table.

Table A partitioned on field 'CID'.
First partition with CID <= MAXVALUE,
second partition with CID <= 10000.

When i will load data in this table, the data will be placed in their right partition...

So... a record with CID=500 will be saved in the second partition, and a record with CID=99999 will be placed in the first partition.

It's right?

Thank you very much for any response!

PS: sorry 4 my beta-version-english!!! Received on Wed May 14 2008 - 03:12:43 CDT

Original text of this message