index rebuild no effect

Question

Post reply

index rebuild no effect

djordan 41144

SSC Enthusiast

Points: 112
More actions
May 14, 2012 at 7:59 pm

#258258

after I rebuild an index that has around 90% fragmentation it has no effect. The operation seem to not error.
What is happening?
thanks!

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

By rebuild has no effect, do you mean fragmentation is still there?

How big is your table (in pages)?

Is it a heap?

djordan 41144 SSC Enthusiast Points: 112 More actions · Answer 2

yes still 70% fragemented.

my table is not a heap table.

table is 11mb. I suppose that means it is 1375 pages big.

Dugi SSCoach Points: 17998 More actions · Answer 3

Take a look to the sweet tool from RedGate that is still free to use and let us know what happened!

http://www.red-gate.com/products/dba/sql-index-manager/%5B/url%5D

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

djordan 41144 SSC Enthusiast Points: 112 More actions · Answer 4

yeah thats pretty good tool! Index is not reported as a problem

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 5

djordan 41144 (5/14/2012)
yes still 70% fragemented.
my table is not a heap table.
table is 11mb. I suppose that means it is 1375 pages big.

That is a very small table. In general I would not worry all that much about fragmentation of a table with that few pages. I would be interested in seeing the table definition including all indexes on the table. Can you please provide those?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

DBA_Dom SSCrazy Points: 2902 More actions · Answer 6

What is the FillFactor for the index?

Also what type of data is in the index?

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

djordan 41144 (5/14/2012)
after I rebuild an index that has around 90% fragmentation it has no effect. The operation seem to not error.

defragmentation generally dosesnt work for small table (1000 data pages) but in your case index rebuild should have reduced the fragmentation percantage down.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

index rebuild no effect

Cookies on SQLServerCentral