Defragmenting a non-index table

• Ahmad Osama

  SSCertifiable

  Points: 7676

  More actions

  February 19, 2008 at 2:28 am

  #182337

  Is there any specific function to defragment a heap.

  Regards,

  Ahmad

  Regards,
  [font="Verdana"]Sqlfrenzy[/font]

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  February 19, 2008 at 2:31 am

  #779616

  According to me you can only defragment the fragmented indexes.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Ahmad Osama

  SSCertifiable

  Points: 7676

  More actions

  February 19, 2008 at 2:38 am

  #779618

  Hi,

  I think that if a table is repopulated with data it will be defragmented.

  Regards,

  Ahmad

  Regards,
  [font="Verdana"]Sqlfrenzy[/font]