Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Another view on analysis and ER

Re: Another view on analysis and ER

From: Jon Heggland <jon.heggland_at_ntnu.no>
Date: Thu, 06 Dec 2007 15:48:02 +0100
Message-ID: <fj923p$ekq$1@orkan.itea.ntnu.no>


Quoth Bob Badour:
> 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.

-- 
Jon
Received on Thu Dec 06 2007 - 08:48:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US