Mike Matrigali wrote:
table partitioning-
The question here is why do want to partition the table. If it
just to spread I/O randomly across disks, I don't think it is a
very useful feature. The same thing can easily accomplished on
most modern hardware/OS's at a lower level while presenting the
disk farm as one disk to the JVM/derby.
One simple but big Table (larger then 1 GByte of Data and expanding)
could be splitted into serveral smaller Units for faster Query processing.
(ORACLE and IBM DB2 are able to partitioning Tables in this way, but
the Price is up to over 30.000 USD $)
Now if you are talking about key partitioning then that may be
useful, but only if accompanying work is done to partition
query execution in parallel against those partitions. Below
I will describe one approach that I think is the easiest and most
maintainable first step towards this.
exactly
