Re: Q: is INDEX synonymous with KEY in SQL92?

From	Norbert_Paul <norbertpauls_spambin@yahoo.com>
Newsgroups	comp.databases
Subject	Re: Q: is INDEX synonymous with KEY in SQL92?
Date	2013-10-03 13:48 +0200
Organization	A noiseless patient Spider
Message-ID	<l2jli5$955$1@dont-email.me> (permalink)
References	<df5d7bcf-bc7d-493c-ba32-74e5621daed2@googlegroups.com> <l2jcl8$q38$1@dont-email.me> <bb4tqdF7aulU1@mid.individual.net>

Show all headers | View raw

Harry Tuttle wrote:
> Norbert_Paul wrote on 03.10.2013 11:16:
>> Ususally this primary key determines the organization of the file that
>> represents the database table
>
> The "usually" part of that statement is not true.
>
> You are probably referring to the concept of a "clustered index" as e.g.
> MySQL or SQL Server are using, but not all DBMS work that way.

No. I am just referring to what I learned at university on database
implementation. See for example p. 60 in
http://wwwiti.cs.uni-magdeburg.de/iti_db/lehre/db2_en/db2-md-english.pdf

Note that the majority (MySQL, SQL Server) of your examples
(MySQL, SQL Server, "not all DBMS") also works that way. Hence your exaples
support "usually" whereas "all" would have been wrong.

Cheers
NP

Thread

Q: is INDEX synonymous with KEY in SQL92? jmichae3@yahoo.com - 2013-09-27 16:54 -0700
  Re: Q: is INDEX synonymous with KEY in SQL92? Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2013-09-30 14:55 +0200
  Re: Q: is INDEX synonymous with KEY in SQL92? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-09-30 16:03 +0200
  Re: Q: is INDEX synonymous with KEY in SQL92? Norbert_Paul <norbertpauls_spambin@yahoo.com> - 2013-10-03 11:16 +0200
    Re: Q: is INDEX synonymous with KEY in SQL92? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-10-03 12:05 +0200
      Re: Q: is INDEX synonymous with KEY in SQL92? Norbert_Paul <norbertpauls_spambin@yahoo.com> - 2013-10-03 13:48 +0200
        Re: Q: is INDEX synonymous with KEY in SQL92? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-10-03 15:51 +0200

csiph-web