Re: Horizontal partitioning

From: KEVIN CLOSSON <kevinc_at_sequent.com>
Date: Tue, 5 Jul 94 15:37:16 GMT
Message-ID: <1994Jul5.153716.16652_at_sequent.com>

>>
>>CREATE TABLESPACE TS DATAFILE
>> 'file1_on_disk1' size ...M,
>> 'file2_on_disk2' size ...M,
>> 'file3_on_disk3' size ...M;
>>
>>CREATE TABLE T (...) TABLESPACE TS
>
>Yes, but I want to be able to control which rows of the table go
>into which partition based around a key value.

   That's because what you're looking for is table partitioning or  fragmentation.

   You'll need DB2 or Informix 7.0 PDQ. The latter offering both round-robin   and expression-based key value fragmentation (row placement).

---

Kevin A. Closson, Senior Technical Support Engineer voice: (503)578-3072 Database Group Leader, World Wide Tech Svcs FAX: (503)578-5453 Sequent Computer Systems

15450 SW Koll Pkwy (MS WIL1-502)               UUCP:     ..uunet!sequent!kevinc
Beaverton, Oregon 97006-6063               internet:         kevinc_at_sequent.com

Received on Tue Jul 05 1994 - 17:37:16 CEST