> IIRC, SQL Server always creates clustered indexes by default for primary
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.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Doug McNaught||Date: 2004-08-26 19:54:04|
|Subject: Re: Anyone familiar with Apple Xserve RAID|
|Previous:||From: Hervé Piedvache||Date: 2004-08-26 19:30:40|
|Subject: Re: TSearch2 and optimisation ...|