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: A pk is *both* a physical and a logical object.

Re: A pk is *both* a physical and a logical object.

From: Lennart <erik.lennart.jonsson_at_gmail.com>
Date: Thu, 12 Jul 2007 16:17:35 +0200
Message-ID: <f75d60$125$1@registered.motzarella.org>


Jan Hidders wrote:
[...]
> To answer the question, I think that is quite simple. As defined in
> the relational model it is a logical concept. As far as I know the SQL
> standard does not state that a PK implies an index (but I could be
> wrong)

I think you are right. Indexes are not even part of core sql, so it seems highly unlikely that it is stated that a PK should imply an index.

/Lennart

[...] Received on Thu Jul 12 2007 - 09:17:35 CDT

Original text of this message

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