Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37

    Unanswered: runstats with 2 different methods

    Hi,Folks

    I'd like to know what's the difference between below 2 ways of db2 runstats.

    something like time comsuming,access plan,...

    db2 runstats on table DM.WEEKLY_HOURS with distribution and indexes all shrlevel change;
    db2 runstats on table DM.WEEKLY_HOURS with distribution and AND DETAILED INDEX ALL;

    which one is better and why?

    Appericate for any advice.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    which one is better and why?
    What are the better?
    Less runstat time?
    Less processor consumtion of runstat?
    Better access path? But, for what queries, for what tables?

    Please see "Usage notes" in Information Center for general considerations.
    Code:
    Usage notes
    
    ...
    ...
    
    2. It is recommended to run the RUNSTATS command: 
    ...
    ...
    
    3. The options chosen must depend on the specific table and the application.
     In general: 
    ...
    ...
    RUNSTATS command - IBM DB2 9.7 for Linux, UNIX, and Windows

  3. #3
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    better refer to less running time and provide better access plan

    for the same query against same table on the same server.

    shrlevel change is a option for v7.however, it works for db2 v8 and v9

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    As you might expect DETAIL INDEXES privides a little more information to the optimzer. I personally would recommend it. It is especially important if you want to use any of the DB2 utilites to tell you whether to reorg the index.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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