Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Question Unanswered: How to Update SYSSTAT Tables in DB2 LUW 9.5

    Can any one tell me of point to some info regarding SYSSTAT.COLGROUPDIST & SYSSTAT.COLGROUPDISTCOUNTS.

    1. I am trying to influence the Optimizer to pick one of the 2 indexes for a particular query. I can change the query cos, it is part of a third party product.

    2. I want to try updating data in the stats tables including the above mentioned ones to see if that would do the trick.

    3. I created Optimization Profile but, DB2 Optimizer ignored it.

    any input is appreciated,


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Just update the tables.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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