Message-ID: <3D7C433D.3080704@ivascu.comNOSPAM>
From: Alex Ivascu <alex@ivascu.comNOSPAM>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9) Gecko/20020513
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Primary and Foreign Key constraints
References: <1031553251.430831@news.thyssen.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 27
NNTP-Posting-Host: 24.126.136.130
X-Complaints-To: abuse@attbi.com
X-Trace: rwcrnsc52.ops.asp.att.net 1031553873 24.126.136.130 (Mon, 09 Sep 2002 06:44:33 GMT)
NNTP-Posting-Date: Mon, 09 Sep 2002 06:44:33 GMT
Organization: AT&T Broadband
Date: Mon, 09 Sep 2002 06:44:33 GMT


Lars Steinmetz wrote:
> Hello NG,
> 
> I have an Oracle Database witch work's with an old client software
> programmed i C++. The client software installed all tables, indexes,
> sequences ect. by itself. Looking into the Oracle-DB, I recognized that no
> primay and no foreign key constraints are implemented. That means that all
> referneces are only known by the client program. Not very stylish...
> Will adding primary key and foreign key constraints to the databases
> increase the performance?
> 
> Thanx for any response.
> 
> 
> --
> ==================
> Lars Steinmetz
> ==================
> 
> 

In most cases adding indexes (i.e. Primary Keys), yes it does.  But, no 
matter what -- FK + PKs are a good idea in any application  - because of 
data integrity enforcement.

Alex Ivascu