does DBCC ShrinkDatabase do a Reorganize of files?

Question

does DBCC ShrinkDatabase doa Reorganize of files?

Basically does it mimic the same process as if i checked Reorganize in the GUI?

Answer 1

No, actually it is notoriously bad for fragmenting the data. You should do a re-org after the shrink is complete.

FROM MSDN:

A shrink operation does not preserve the fragmentation state of indexes in the database, and generally increases fragmentation to a degree. This is another reason not to repeatedly shrink the database.

Answer 2

• Shrink is file shrinkage and does DBCC SHRINKDATABASE or DBCC SHRINKFILE
• Reorganise is index maintenance, invoked by ALTER INDEX

No overlap except in some rare cases where you have heaps (tables without clustered indexes)