Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Basic: Index on Primary Key
Hi..All,
This might be a basic question. As far as I have learned, we should first create an Index(es) on the column(s) identified as primary key of a table. Then alter the table to create the primary key, so that the Key automatically uses the index instead of creating its own index in the system tablespace. How much of this is true?
TIA
-- Regards, PraveenReceived on Fri Mar 29 2002 - 01:24:21 CST