X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C75325E46D4 for ; Thu, 26 Aug 2004 16:48:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93962-02 for ; Thu, 26 Aug 2004 19:48:49 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 5DB845E46D1 for ; Thu, 26 Aug 2004 16:48:48 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6183909; Thu, 26 Aug 2004 12:50:06 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Magnus Hagander" , "J. Andrew Rogers" , "Bruce Momjian" Subject: Re: Equivalent praxis to CLUSTERED INDEX? Date: Thu, 26 Aug 2004 12:48:25 -0700 User-Agent: KMail/1.4.3 Cc: , References: <6BCB9D8A16AC4241919521715F4D8BCE475B39@algol.sollentuna.se> In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE475B39@algol.sollentuna.se> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200408261248.25661.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/374 X-Sequence-Number: 8010 Magnus, > IIRC, SQL Server always creates clustered indexes by default for primary > keys. I think that's a per-database setting; certainly the ones I admin do not. However, since SQL Server orders its data pages, those data pages tend to be in the order of the primary key regardless if there is no clustered index. -- Josh Berkus Aglio Database Solutions San Francisco