Skip site navigation (1) Skip section navigation (2)

Re: Equivalent praxis to CLUSTERED INDEX?

From: Mischa Sandberg <ischamay(dot)andbergsay(at)activestateway(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Date: 2004-08-26 21:41:04
Message-ID: QNsXc.56331$X12.35308@edtnps84 (view raw or flat)
Thread:
Lists: pgsql-performance
J. Andrew Rogers wrote:
> On Thu, 2004-08-26 at 12:30, Magnus Hagander wrote:
>>IIRC, SQL Server always creates clustered indexes by default for primary
>>keys.
> 
> That would surprise me actually.

Yaz, it should. It doesn't ALWAYS create clustered (unique) index for 
primary keys, but clustered is the default if you just specify

CREATE TABLE Foo (col1, ...
	,PRIMARY KEY(col1, ...)
)

Saying PRIMARY KEY NONCLUSTERED(...) is how you override the default.
	
((Weird to be discussing so much MSSQL here))

In response to

pgsql-performance by date

Next:From: Mischa SandbergDate: 2004-08-26 21:46:13
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Previous:From: Gaetano MendolaDate: 2004-08-26 21:09:35
Subject: Re: Equivalent praxis to CLUSTERED INDEX?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group