Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases > #439

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

Path csiph.com!usenet.pasdenom.info!aioe.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From Harry Tuttle <SOZRBLNTLEEE@spammotel.com>
Newsgroups comp.databases
Subject Re: Q: is INDEX synonymous with KEY in SQL92?
Date Thu, 03 Oct 2013 12:05:05 +0200
Lines 7
Message-ID <bb4tqdF7aulU1@mid.individual.net> (permalink)
References <df5d7bcf-bc7d-493c-ba32-74e5621daed2@googlegroups.com> <l2jcl8$q38$1@dont-email.me>
Mime-Version 1.0
Content-Type text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding 7bit
X-Trace individual.net S5XkcBJ+jG+WCZoHrRqXlQ/nPBvFcZsxD85T1GFGUtVprtSU8=
Cancel-Lock sha1:GJFV9Jz5rFBW4DaMkSeNmDKC+zU=
User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To <l2jcl8$q38$1@dont-email.me>
Xref csiph.com comp.databases:439

Show key headers only | View raw

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.

Back to comp.databases | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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