Link to home
Start Free TrialLog in
Avatar of spkvijay
spkvijay

asked on

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.
Avatar of Steve Wales
Steve Wales
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of RRobinho
RRobinho

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial