Re: [PERFORM] Equivalent praxis to CLUSTERED INDEX?

[Mischa Sandberg]

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.


Advertising






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))
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match