Re: tough choices

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sun, 20 Jun 2004 18:27:32 +1000
Message-ID: <40d54a65$0$25461$afc38c87@news.optusnet.com.au>

"Mark Townsend" <markbtownsend_at_comcast.net> wrote in message news:40D54106.4050409_at_comcast.net...
> Mark A wrote:
>
> <snip>
>
> > since both DB2 for z/OS and Oracle only support share-everything
> > parallelism, that is what they both have range partitioning instead of
hash
> > partitioning (hash partitioning is designed to split the load evenly
across
> > all partitions).
>
>
> Oracle also has hash partitioning, for the same reasons. Oracle also has
> list partitioning, and indeed range-hash and list-hash.

Minor point, but actually Oracle 9i has range-list and range-hash composite partitioning, but not list-hash.

Regards
HJR Received on Sun Jun 20 2004 - 03:27:32 CDT