Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Primary and Foreign Key constraints
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 Received on Mon Sep 09 2002 - 01:44:33 CDT