Re: Is a primary key always desired?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 16 Dec 2003 06:49:07 +0100
Message-ID: <j57ttv4mosttei0jfa2551d259e10v1o3s@4ax.com>

On Mon, 15 Dec 2003 22:09:31 -0000, Paul <paul_at_not.a.chance.ie> wrote:

>Can't the RI be enforced by triggers if, for some reason, the guy
>doesn't want to use primary keys? Not saying that it's a good thing,
>just that it is a possibility - legacy data? Whatever?
>

Experiments on a real system showed this is not an option, being about 8 times slower.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Dec 15 2003 - 23:49:07 CST