Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    67

    Unanswered: Convert type1 index to type2 index

    Hi All,

    I am going to upgrade our database from v7.2 to v9.7 so

    a- upgrade database from v7.2 to 8.2
    b- convert typ1 index to typ2 index via "reorg indexes all on table xxxx convert
    c- upgrade to 9.7

    OR


    a- upgrade database from v7.2 to 8.2
    b- upgrade to 9.7
    c-reorg database via "reorg table xxxx " for all tables.


    please let me know which approach is correct

    Thank you in advance for your help.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Either way should work.

    Andy

Posting Permissions

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