Re: Another view on analysis and ER
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 06 Dec 2007 12:41:13 -0400
Message-ID: <4758262a$0$5303$9a566e8b_at_news.aliant.net>
>
>
> Keys are, but key /primacy/ is not. If one ignores any performance
> differences between a primary key and any other key (as of course one
> should, although it may not be possible in current SQL systems), the
> remaining difference is merely syntactical convenience---hardly a
> logical issue.
Date: Thu, 06 Dec 2007 12:41:13 -0400
Message-ID: <4758262a$0$5303$9a566e8b_at_news.aliant.net>
Jon Heggland wrote:
>>Keys and references are logical issues and not physical issues. Physical >>issues affect only performance.
>
>
> Keys are, but key /primacy/ is not. If one ignores any performance
> differences between a primary key and any other key (as of course one
> should, although it may not be possible in current SQL systems), the
> remaining difference is merely syntactical convenience---hardly a
> logical issue.
That's an interesting take on it. While it is a syntactical shorthand, it is a shorthand for a logical consideration. Received on Thu Dec 06 2007 - 17:41:13 CET