Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Primary and Foreign Key constraints
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" <no_spam_lsteinmetz_at_jakrause.com> schrieb im Newsbeitrag
news:1031553251.430831_at_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
> ==================
>
>
Received on Mon Sep 09 2002 - 01:43:55 CDT