| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
"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_at_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_at_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_at_sprintmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: james ellis INET: jellis24_gso_at_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_at_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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Primary keys vs. unique indexes</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>What? Yes you can. I have anyway. </FONT> </P> <P><FONT SIZE=3D2>Can you give me an example of when that would not = work?</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"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."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: james ellis [<A = HREF=3D"mailto:jellis24_gso_at_yahoo.com">mailto:jellis24_gso_at_yahoo.com</A>= ]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, November 30, 2000 11:51 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Primary keys vs. unique indexes</FONT> </P> <BR> <P><FONT SIZE=3D2>The main difference is you can not reference an = unique</FONT> <BR><FONT SIZE=3D2>index with a foreign key. </FONT> <BR><FONT SIZE=3D2>--- cemail_at_sprintmail.com wrote:</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> What is the difference between building a table = and</FONT> <BR><FONT SIZE=3D2>> including</FONT> <BR><FONT SIZE=3D2>> the primary key versus building the table and = then</FONT> <BR><FONT SIZE=3D2>> having creating</FONT> <BR><FONT SIZE=3D2>> a unique index on the same keys? When you = create a</FONT> <BR><FONT SIZE=3D2>> table with</FONT> <BR><FONT SIZE=3D2>> a primary key, doesn't Oracle store it as an = index</FONT> <BR><FONT SIZE=3D2>> anyway?</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> -----</FONT> <BR><FONT SIZE=3D2>> Sent using MailStart.com (</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://MailStart.Com/welcome.html" = TARGET=3D"_blank">http://MailStart.Com/welcome.html</A> )</FONT> <BR><FONT SIZE=3D2>> The FREE way to access your mailbox via any = web</FONT> <BR><FONT SIZE=3D2>> browser, anywhere!</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ:</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Author: </FONT> <BR><FONT SIZE=3D2>> INET: cemail_at_sprintmail.com</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX:</FONT> <BR><FONT SIZE=3D2>> (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public = Internet</FONT> <BR><FONT SIZE=3D2>> access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an</FONT> <BR><FONT SIZE=3D2>> E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of</FONT> <BR><FONT SIZE=3D2>> 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB</FONT> <BR><FONT SIZE=3D2>> ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed</FONT> <BR><FONT SIZE=3D2>> from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information</FONT> <BR><FONT SIZE=3D2>> (like subscribing).</FONT> </P> <BR> <P><FONT = SIZE=3D2>__________________________________________________</FONT> <BR><FONT SIZE=3D2>Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>Yahoo! Shopping - Thousands of Stores. Millions of = Products.</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://shopping.yahoo.com/" = TARGET=3D"_blank">http://shopping.yahoo.com/</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: james ellis</FONT> <BR><FONT SIZE=3D2> INET: jellis24_gso_at_yahoo.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Thu Nov 30 2000 - 11:20:50 CST
 |
 |