Hash Clustered Table Question
From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Mon, 9 Jun 2008 20:20:34 -0400
Message-ID: <lNj3k.5485$jI5.5481@flpi148.ffdc.sbc.com>
Date: Mon, 9 Jun 2008 20:20:34 -0400
Message-ID: <lNj3k.5485$jI5.5481@flpi148.ffdc.sbc.com>
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. Received on Mon Jun 09 2008 - 19:20:34 CDT