This is a discussion on RE: Oracle 10G within the Informix forums, part of the Database Server Software category; --> > > CREATE TABLE hash_products > ( product_id NUMBER(6) > , product_name VARCHAR2(50) > , product_description VARCHAR2(2000) > , ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > > CREATE TABLE hash_products > ( product_id NUMBER(6) > , product_name VARCHAR2(50) > , product_description VARCHAR2(2000) > , category_id NUMBER(2) > , weight_class NUMBER(1) > , warranty_period INTERVAL YEAR TO MONTH > , supplier_id NUMBER(6) > , product_status VARCHAR2(20) > , list_price NUMBER(8,2) > , min_price NUMBER(8,2) > , catalog_url VARCHAR2(50) > , CONSTRAINT product_status_lov > CHECK (product_status in ('orderable' > ,'planned' > ,'under development' > ,'obsolete') > ) ) > PARTITION BY HASH (product_id) > PARTITIONS 5 > STORE IN (tbs_1, tbs_2, tbs_3, tbs_4); > > Could have fooled me. > Yes, it did. This is not a distributed hash table. This is a table fragmented by hash. sending to informix-list |