Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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