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?

From Harry Tuttle <SOZRBLNTLEEE@spammotel.com>
Newsgroups comp.databases
Subject Re: Q: is INDEX synonymous with KEY in SQL92?
Date 2013-10-03 12:05 +0200
Message-ID <bb4tqdF7aulU1@mid.individual.net> (permalink)
References <df5d7bcf-bc7d-493c-ba32-74e5621daed2@googlegroups.com> <l2jcl8$q38$1@dont-email.me>

Show all headers | 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 | NextPrevious 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