Solved

Rebuild Index does not defragment  in SQL 2005

Posted on 2013-01-08
2
352 Views
Last Modified: 2013-01-09
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
Comment
Question by:spkvijay
2 Comments
 
LVL 22

Expert Comment

by:Steve Wales
ID: 38754696
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
 
LVL 2

Accepted Solution

by:
RRobinho earned 500 total points
ID: 38757877
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question