February 23, 2011 at 10:56 am
I have a table with billion records in it and the fragmentation of clustered and non clustered indexes on this table is more than 70%.
I want to rebiuld the indexes on the table.
Can any one suggest the minimum time it will take to rebuild the indexes on the table as are doing a background planning work.
Sandhya
February 23, 2011 at 11:55 am
With the given information, there really isn't any way that this could be determined. The number/type of CPUs, memory available, disk throughput, and the width of the rows will have a significant bearing on this.
That being said. I rebuilt the clustered index on a table with a billion rows once and it took 6 hours. Unfortunately, that won't mean much to you since the schema of your table and the data within it are not likely the same. That server was IO strapped so with a little reconfiguring that time probably wasn't representative of what it should have been.
February 23, 2011 at 12:09 pm
In addition to all that excellent informatoin, don't forget that you may also have deal with resource contention, assuming this is a production system.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2011 at 1:56 pm
Also, fragmentation only really has a major impact on index scans, its a lot less detrimental if you are doing index seeks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply