Thread: Creating a table
05-05-03, 16:00 #1Registered User
- Join Date
- Apr 2003
Unanswered: Creating a table
When creating a table using "ORGANIZE BY(<column>, <column>)" - must these columns be unique? (I hope not-but doc is not clear).... What is the deference between this and PARTITIONING KEY?
Will a Unique index be created on "PARTITIONING KEY" values?
And finally, what is "USING HASHING" - how does it work?
The documentation is a little thin on this - or I just didn't find the right information....
Thanks in advance for the clarification!
Rick - F.S.U.
05-15-03, 10:01 #2Registered User
- Join Date
- May 2003
If I understand these new concepts correctly then
"organize by" is a way to cluster similar data together.
Like if you did a reorg with an index.
Pages of the table are stored in blocks size=extentsize
and within a block all dimension values are equal.
Partitioning keyes and using hashing applies to partitioned (multiple nodes) databases only. With hashing you randomly spread the data accross the available nodes.
A partition key is not necessarily unique, since if you specify a primary key as partition key only the first column of that primary key will be used for partitioning.Anton Versteeg