View Single Post

   
  #1 (permalink)  
Old 05-16-2008, 01:38 PM
zmaker
 
Posts: n/a
Default table partitioning doubt

Hi!
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!
Ciao!

PS: sorry 4 my beta-version-english!!!

Reply With Quote