clustered vs. heap tables

[equus2]

Hello,

I am trying to solve a disagreement with a coworker.

Does running DBCC REINDEX on a heap table have any effect?

My position is no, it does not. A run of DBCC SHOWCONTIG before and after shows that the statistics do NOT change whatsoever.

However, his position is that by running DBCC REINDEX will improve the performance of the index.

Who is right?

 

[equus2]

I think the short answer to this is, rebuilding non clustered indexes won't order the heap, but it can defrag the index itself.