> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to