Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: reorg with indexscan

    hi

    reorg table tabname index indname inplace allow wirte access,

    indname if i specify will it increase my performance

    reorg table tabname inplace allow write access

    will this uses a index available in table by default for performing reorg on table

    kindly suggest

    regds
    Paul

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    according the doc
    INDEX index-name
    Specifies an individual index to be reorganized
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Mathew_paul View Post
    will it increase my performance
    Your performance?

    Specifying an index in the REORG TABLE command will tell DB2 to sort table rows by that index. Whether it increases performance of queries after the REORG depends on the queries.

    Quote Originally Posted by Mathew_paul View Post
    kindly suggest
    REORG INDEXES/TABLE command - IBM DB2 9.7 for Linux, UNIX, and Windows
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    thks for reply

    sorry for composing the query in wrong way,

    n i

    i mean improving the performance of REORG itself which is taking long time, coz its running on table of 100G and table don't have any index. (seriously no index) But client perform reorg on this table reguraly, INDEX indexname clause as u said is used to sort in sort phase for reorg will that be more faster compare to table scan in sort phase.

    guy

    I was pointing at this clause of reorg table.

    Table clause

    |--+-------------------+---------------------------------------->
    '-INDEX--index-name-'

    thks
    Paul

    thks
    Paul

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    No, having an index will not make REORG run faster.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Nov 2011
    Posts
    334
    If you specifies a index when reorging table , it will increase the exectuing time.
    Because if you just want to reclaim the space ( without specifing a index ), there will be no extra sort phase.

Posting Permissions

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