RE: Need for primary keys

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 31 May 2007 13:55:21 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9E6AC2F@usahm208.amer.corp.eds.com>

Well, if there are no PK constraints defined in the database for 60% of your tables then there are no FK constraints defined to 60% of your tables. This could be a problem or you could just have a huge number of transition/interface tables used to load or extract data from your database. You probably need to look a little closer at what the tables are used for.

Generally speaking it is good form to define PK constraints on every table that has a suitable PK candidate. Tables used only as part of a load or extract process often have no need for a PK since it will never be used, but this should be a small percentage of the total.

Mark D Powell -- Phone (313) 592-5148

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BLock_at_dvfs.com

	Sent: Thursday, May 31, 2007 12:08 PM
	To: oracle-l_at_freelists.org
	Subject: Need for primary keys
	
	

	I just started at a new company about 4 months ago and I noticed

that about 4800 of the 7900 tables ( 60% ) do not have primary keys.

Is this a problem that I should bring to management or is it more based on the business/application needs?

Thanks

	Brian Lock
	DBA - East Campus
	ex: 22341

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 31 2007 - 12:55:21 CDT