Message-Id: <10696.123333@fatcity.com> From: "Koivu, Lisa" Date: Thu, 30 Nov 2000 12:20:50 -0500 Subject: RE: Primary keys vs. unique indexes This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C05AF1.E77154DA Content-Type: text/plain; charset="iso-8859-1" What? Yes you can. I have anyway. Can you give me an example of when that would not work? Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -----Original Message----- From: james ellis [mailto:jellis24_gso@yahoo.com] Sent: Thursday, November 30, 2000 11:51 AM To: Multiple recipients of list ORACLE-L Subject: Re: Primary keys vs. unique indexes The main difference is you can not reference an unique index with a foreign key. --- cemail@sprintmail.com wrote: > > What is the difference between building a table and > including > the primary key versus building the table and then > having creating > a unique index on the same keys? When you create a > table with > a primary key, doesn't Oracle store it as an index > anyway? > > ----- > Sent using MailStart.com ( > http://MailStart.Com/welcome.html ) > The FREE way to access your mailbox via any web > browser, anywhere! > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: cemail@sprintmail.com > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: james ellis INET: jellis24_gso@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C05AF1.E77154DA Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Primary keys vs. unique indexes

What?  Yes you can.  I have anyway.

Can you give me an example of when that would not = work?

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."


-----Original Message-----
From: james ellis [mailto:jellis24_gso@yahoo.com= ]
Sent: Thursday, November 30, 2000 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Primary keys vs. unique indexes


The main difference is you can not reference an = unique
index with a foreign key.
--- cemail@sprintmail.com wrote:
>
> What is the difference between building a table = and
> including
> the primary key versus building the table and = then
> having creating
> a unique index on the same keys?  When you = create a
> table with
> a primary key, doesn't Oracle store it as an = index
> anyway?
>
> -----
> Sent using MailStart.com (
> http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any = web
> browser, anywhere!
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
>   INET: cemail@sprintmail.com
>
> Fat City Network Services    -- = (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, = California        -- Public = Internet
> access / Mailing Lists
>
---------------------------------------------------------------= -----
> To REMOVE yourself from this mailing list, send = an
> E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling = of
> 'ListGuru') and in
> the message BODY, include a line containing: = UNSUB
> ORACLE-L
> (or the name of mailing list you want to be = removed
> from).  You may
> also send the HELP command for other = information
> (like subscribing).


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of = Products.
http://shopping.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: james ellis
  INET: jellis24_gso@yahoo.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San Diego, = California        -- Public Internet = access / Mailing Lists
---------------------------------------------------------------= -----
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of = 'ListGuru') and in
the message BODY, include a line containing: UNSUB = ORACLE-L
(or the name of mailing list you want to be removed =