Results 1 to 3 of 3

Thread: Reorg

  1. #1
    Join Date
    Jun 2003
    Posts
    140

    Unanswered: Reorg

    hi all


    Is UPDATE STATISTICS reqired after REORG or REORG itself does it ?
    (using anyoption with REORG)


    thx
    perl

  2. #2
    Join Date
    Nov 2003
    Location
    Zurich, Switzerland
    Posts
    7
    you should run update statistics after re-org, reorg rebuild only reindexes.

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    REORG is typically run on DOL tables.

    Update stats is run on all tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •