Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Karachi,pakistan
    Posts
    17

    Unanswered: RE Indexing in DB2 v7.1

    How to re index a table in db2 udb v7.1?

    Thanks in Advance
    A.Dee

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Why do you think you need to "re index" the table?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    May 2006
    Posts
    82
    Hi, I'm sorry i have never heard of re index. can anyone please tell me that. Is that about INDEX ALL while doing RUNSTATS..? or is that DELETING the index and Recreating it as we cannot ALTER INDEX. please help

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    I have never heard of "re index". So it can be multiple thinks like:
    - recreating index (drop index, create index)
    - reorganizing index (reorg table)
    - etc.

    ADee, can you please describe what you would like to do? Please also provide operating system you are using db2 on.

    Hope this helps,
    Grofaty

Posting Permissions

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