Table Fragmentation

Question

Post reply

Table Fragmentation

cqldba

SSC Enthusiast

Points: 182
More actions
February 26, 2008 at 12:31 pm

#186935

How should I check fragmenting of the table and how can i defragment that ?

Viewing 4 posts - 1 through 3 (of 3 total)

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

SanjayAttray SSChampion Points: 13157 More actions · Answer 1

You can check by executing dbcc showcontig on the database and then execute dbcc dbreindex command.

Check books online for more details.

SQL DBA.

john j serna SSChasing Mays Points: 630 More actions · Answer 2

dbcc showcontig in fact shows you the table fragmentation, but dbcc indexdefrag defrags the index, not the table, so the question is.. How do I defrag a table?

I am looking for the answer on internet but there aren´t good answers, i think the solution is recreating the table on a different filegroup.

bbhattacharya SSC Journeyman Points: 89 More actions · Answer 3

Do you have clustered index on this table? If you do, you can reindex that clustered index and it will reorg the table. If you don't, create a clustered index on the table. That will reorganize the table. Then drop the clustered index.