title: Reorganize index and level of defragmentation
body: <p>I found this question <a href="http://realworlddba.wordpress.com/2008/02/04/index-rebuild-versus-reorganize-whats-the-difference/" rel="nofollow">here</a> but no answer yet:</p>
  
  <p>If an index is heavily fragmented (over 50 percent) will the <code>alter index reorganize</code> reduce the level of the fragmentation?</p>