Posted by Erland Sommarskog on 06/09/06 22:02

(wackyphill@yahoo.com) writes:
> Every table has a primary key which I believe (correct me if I'm wrong)
> would give them a clustered Index.

By default, when you create a primary key, this results in a clustered
index. However, that does not mean that just because there is a PK,
that there is a clustered index on the table, as the PK can deliberately
have been created as non-clustered.

(And in many cases, clustering on the PK is not the best choice.)

As for your original question, am I right to suspect that the table
in question is fairly small? If there is only data for 1½ index page,
there will be some free space that will look like fragmentation.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]