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>
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

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.