Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is a primary key always desired?
"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