RE: Oracle 10G
>
> 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