Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

Rebuild Index does not defragment in SQL 2005

Hi,

Rebuild Index does not defragment

I have a usertable (Avg 80%) after rebuilding, it is still showing 80%, Why it showing same.
Like this i having some problem with many tables.
I am using Sql Server 2005 Standard Edition.
0
spkvijay
Asked:
spkvijay
1 Solution
 
Steve WalesSenior Database AdministratorCommented:
Is it a small table/index ?  On a small index, rebuilding it doesn't necessarily reduce fragmentation, see the documentation - check in the section under Rebuilding Indexes
0
 
RRobinhoCommented:
Agree with sjwales
I am guessing these indexes are very small.

Rebuilding of very small indexes will still look fragmented because objects that are small like this are stored on mixed extents which can be shared by different objects

If you try the same thing on a larger index you will see that this won't happen because there are enough pages in the larger one for it to have its own extents that are allocated to just that object
So i will suggest you to defragment your table or the whole database if rebuilding the indexes is not enough to avoid  fragmentation problem
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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