From: "Lars Steinmetz" Newsgroups: comp.databases.oracle.server Subject: Primary and Foreign Key constraints Date: Mon, 9 Sep 2002 08:39:21 +0200 Organization: Ye 'Ol Disorganized NNTPCache groupie Lines: 19 Message-ID: <1031553251.430831@news.thyssen.com> NNTP-Posting-Host: 149.211.49.31 X-Trace: goliath.news.is-europe.net 1031553563 3821 149.211.49.31 (9 Sep 2002 06:39:23 GMT) X-Complaints-To: abuse@is-europe.net NNTP-Posting-Date: 9 Sep 2002 06:39:23 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Cache-Post-Path: news.thyssen.com!unknown@149.206.160.10 X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/) 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 ==================