From: "Jan Gelbrich" Newsgroups: comp.databases.oracle.server Subject: Re: Primary and Foreign Key constraints Date: Mon, 9 Sep 2002 08:43:55 +0200 Lines: 40 Message-ID: References: <1031553251.430831@news.thyssen.com> NNTP-Posting-Host: gateway.westfalen-blatt.de (195.177.181.10) X-Trace: fu-berlin.de 1031554031 60536896 195.177.181.10 (16 [152732]) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Hi Lars, Yes, of course it will improve your db when You add PKs (on the ID column of any table) and FKs properly. There is just one job left for You: You would have to find out what FKs are there... in some cases You could read it out of the column names - if the db goes conform to any naming standards, eg. parent tables´ ID refers to child tables XYZ_ID or such ... You could use Oracle Schema Builder for Your purposes, too. Hope this helps Jan "Lars Steinmetz" schrieb im Newsbeitrag news:1031553251.430831@news.thyssen.com... > 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 > ================== > >