Home -> Usenet -> comp.databases.oracle -> Primary Keys vs. Unique Index

Primary Keys vs. Unique Index

From: louis.avrami..jr <lou2_at_cbnews.att.com>
Date: Sat, 10 Dec 1994 08:02:55 GMT
Message-ID: <D0L50v.998_at_nntpa.cb.att.com> 






In the v7.1.3 Server Administrator's Guide, it's stated that it is 
"better" to create an index via a PRIMARY KEY within a schema, than
via a CREATE UNIQUE INDEX statement.  Is there a reason for this?
My group is just beginning to migrate to v7.1.3, and we have quite a
few schemas that would need extensive updating, as well as processes
like maintenance and data loads that would need to be rethought, with
PRIMARY KEY indexes.



Thanks,



Lou Avrami ( attmail!lavrami )
Received on Sat Dec 10 1994 - 09:02:55 CET












Original text of this message