Post reply

Does Reorg unload/reload data?

  • June 26, 2003 at 11:48 am

    #59683

    Does reorganize data actually unload and reload table data? Does DBREINDEX unload/reload data or just work at the index level?

  • June 26, 2003 at 12:32 pm

    #463326

    quote:

    Does reorganize data actually unload and reload table data? Does DBREINDEX unload/reload data or just work at the index level?

    Do not quite understand the unload/reload here. It does drop the indexes and re-create the indexes.

  • June 26, 2003 at 12:38 pm

    #463329

    By unload/reload I mean the data is actually moved around and defragmented. I don't know of any utility, DBCC or otherwise, that will do this for table data, not just the index.

  • June 26, 2003 at 12:42 pm

    #463331

    Depends on what kind of indexes table has. If there is a cluster index for the table, dbcc dbreindex will reorganize the data according the clustered index and fill factor. If there is not cluster index, it will just rebuild the indexes themself.

    You may look into dbcc indexdefrag in BOL too.

    Edited by - Allen_Cui on 06/26/2003 12:47:35 PM

  • June 27, 2003 at 5:42 am

    #463422

    jguff: Please keep the same question in one topic.

  • June 27, 2003 at 9:52 am

    #463493

    OK, to wrap it up, I'll identify fragmented tables using DBCC SHOWCONTIG (Scan Density); then drop and recreate any clustered index (or create a new clustered index)(without using the SORTED_DATA option). Thanks, buddies!

  • June 27, 2003 at 10:04 am

    #463496

    quote:

    I'll identify fragmented tables using DBCC SHOWCONTIG (Scan Density); then drop and recreate any clustered index (or create a new clustered index)

    Well, you could also listen to what Allen said:

    quote:

    You may look into dbcc indexdefrag in BOL too.

Viewing 7 posts - 1 through 6 (of 6 total)

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