Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Primary keys vs. unique indexes

Primary keys vs. unique indexes

From: <cemail_at_sprintmail.com>
Date: Wed, 29 Nov 2000 21:57:07 -0800
Message-Id: <10695.123285@fatcity.com>


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! Received on Wed Nov 29 2000 - 23:57:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US