Solved

Rebuild Index does not defragment  in SQL 2005

Posted on 2013-01-08
2
350 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Testing connection to sql 7 59
Can Unique column have more than one Null? 8 53
How can i use WITH CTE for checking exist value? 3 33
SQL Error - Query 6 25
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…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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