| 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 Constraints and Indexes
Why are you creating the PK like that? Create the PK, then create the index
after the table is created.
Wouldn't that accomplish what you want?
Kev
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Wayne
McGill
Sent: Wednesday, January 10, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L
Subject: Primary Constraints and Indexes
As a part-time dba, I am confused about the differences between Primary Keys and Indexes.
For example if I create a table "EMPLOYEES" and in the table creation statement I do something like:
create table ...
constraint XXX primary key (EMP_ID) using index ...
then later I create an index:
create index YYY on EMPLOYEE (EMP_ID) ... I know I have created two indexes (the first one system-named and implicitly created and the second name YYY and created explicitly) but do I really need the second index YYY? It seems to me the YYY index is not really needed? Can someone shed some light on this for me.
THANKS, Wayne
McGillWL_at_navair.navy.mil
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wayne McGill
INET: McGillWL_at_navair.navy.mil
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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). Received on Wed Jan 10 2001 - 10:34:51 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |