Re: poor man's partitioning

From: Paul Drake <bdbafh_at_gmail.com>
Date: 21 Oct 2004 17:57:15 -0700
Message-ID: <910046b4.0410211657.18399970@posting.google.com>

netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<4177fe38.868359454_at_localhost>...
> All,
>
> How would you do hash partitioning on a table (e.g. you were running
> Standard edition).
>
> With range partitioning, I assume it's easy, just create a view on top
> of X tables (e.g. for every month).
>
> Thanks
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email

OW! Brain hurt.

An instead of insert trigger might take care of the distributing by hash_function (mod?) ... but

How is the CBO going to perform partition pruning on hash partitioning without using the partitioning option?

Its tough enough to get partition pruning working on range data without the partitioning option (nothing is easy).

I'd like to see the test case.

-bdbafh Received on Thu Oct 21 2004 - 19:57:15 CDT