Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: Is reorg necessary after dropping primary key on a table

    Hi, Is reorg necessary after dropping a primary key on a table ?

    THanks,
    Panditt
    Thanks,
    idb2dba

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No, why do you ask?

    Andy

  3. #3
    Join Date
    Aug 2008
    Posts
    76
    Thanks Andy. I am asking as I was bit skeptical about.
    Thanks,
    idb2dba

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You should do runstats though.

    Andy

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Adding or dropping a unique constraint (with a PK being a unique constraint with a special name only) does not change the data in the table. Thus, no reorg is necessary because there is no reason to do something on every row.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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