RE: Need for primary keys

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 31 May 2007 13:55:21 -0400

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of BLock@xxxxxxxx
        Sent: Thursday, May 31, 2007 12:08 PM
        To: oracle-l@xxxxxxxxxxxxx
        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? 
        Brian Lock
        DBA - East Campus
        ex: 22341

Other related posts: