Search code examples
sql-server-2005clustered-indexdatabase-indexes

Clustered Index total fragmentation to high (66.67%)

i have a table with just 7 columns and 400 rows. There is a clustered Index on its Primary Key column. The index page Fullness is 68.98% and Total Fragmentation is 66.67%.

This is a table that i use in 90% of the application queries and i have a feeling its slowing down the quite alot of queries because of the high fragmentation percentage. Any advice?

Observation: Out of the 7 columns in the table, 3 columns completely have NULL value for all rows, could this be the cause?

Solution

  • You can't get meaningful fragmentation figures for tables that occupy just a few 8k data pages. The indexes take even less: I'd guess at 2 pages max for the index

    Don't worry about it.