• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

SQL 2005 index fragmentation

After i use DBCC DBREINDEX(orders), i get the following results regarding Average Fragmentaiton of each index.  Can you interpret the results?  The clustered index have a fragmentation of 0% but the non clustered still look like a mess?

Orders      CLUSTERED INDEX      0%
Orders      CLUSTERED INDEX      0%
Orders      NONCLUSTERED INDEX      67%
Orders      NONCLUSTERED INDEX      67%
Orders      NONCLUSTERED INDEX      50%
Orders      NONCLUSTERED INDEX      50%
0
dastaub
Asked:
dastaub
2 Solutions
 
Daniel_PLDB Expert/ArchitectCommented:
Try ALTER INDEX:
 
ALTER INDEX ALL ON Orders REBUILD;
GO

Open in new window

0
 
Aaron ShiloChief Database ArchitectCommented:
you shuold use the ONLINE option. to minimize impact on production. (for enteprize edition only)

ALTER INDEX ALL ON Orders      REBUILD WITH (online= on)
0
 
dastaubAuthor Commented:
DBCC DBREINDEX(orders)
AND
ALTER INDEX ALL ON Orders REBUILD

produced same result
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now