Re: Is a primary key always desired?

From: Thomas T <T_at_T>
Date: Fri, 3 Oct 2003 17:12:57 -0400
Message-ID: <3f7de65b$1@rutgers.edu>

"Randy Harris" <randy_at_SpamFree.com> wrote in message news:mzlfb.5646$Hd6.3652502_at_newssvr28.news.prodigy.com...
> I'm sure this is another dumb question, your patience is appreciated.
>
> Should every table in an Oracle database have a Primary Key? What about a
> very small table that is used for a very short list of values?

You could create it as an IOT, an index-organized table... usually used for a table that's mainly for lookup, without many additions/changes.

-Thomas Received on Fri Oct 03 2003 - 16:12:57 CDT