Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    42

    Unanswered: runstats on table with no indexes

    Is it necessary to perform runstats on a table with no indexes. DB2 has to scan the table anyway. Where can runstats help? Please explain.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    At least, it might influence on join method(and join sequence, if you joined more than two tables).

  3. #3
    Join Date
    Aug 2009
    Posts
    42
    No joining with other tables. This table is an MQT and is queried directly. No indexes are created on MQT. Any benefit from runstats?

  4. #4
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    If the query for base table was not and you queried MQT directly,
    I can't expect any benefit from runstats(in that very limited situation).

Posting Permissions

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