Re: Hash Clustered Table Question

Dereck L. Dietz wrote:
> I'm reading Tom Kyte's Expert Oracle Database Architecture about Hash
> Clusted Tables and have a question about something I'm obviously
> overlooking.
>
> I've never used hash tables before but wanted to experiment. I have a small
> lookup table with only 110 rows. If I make that into a hash clustered table
> will the hash key suffice or would I also have to include a primary key?
>
> Sorry if this is a simple question but I must be overlooking the obvious
> somewhere.
>
> Thanks.
>
>

The obvious question would be what problem are you trying to solve? If the the table is small enough, your memory large enough and is hit often enough, may end up being cached in memory anyway. If it is that small, just pin it in memory and your I/O is moot. If it is just for the experience, the others have answered well. Received on Wed Jun 11 2008 - 21:57:19 CDT