Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Question Unanswered: Indexing problems

    Hi All DB2 8.1 FP 5 (.0.48) on AIX 5.2.0.0

    After upgrading to 8.1.5 all my indexes seem
    to have chanced the indexed column to the
    include parameter and the optimizer rarely
    select the index - has anyone experienced
    anything similar ?

    Thanks
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Have you done RUNSTATS follwed by rebind??

    Cheers
    Sathyaram

    Quote Originally Posted by Tank
    Hi All DB2 8.1 FP 5 (.0.48) on AIX 5.2.0.0

    After upgrading to 8.1.5 all my indexes seem
    to have chanced the indexed column to the
    include parameter and the optimizer rarely
    select the index - has anyone experienced
    anything similar ?

    Thanks
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2002
    Location
    Chicago
    Posts
    10
    Do RUNSTATS and then do an EXPLAIN of your query - I suspect it will choose a new access path once the statistics are updated. If you see a better access path will be taken, rebind the program.

  4. #4
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow

    I have - of course - runstatted severeal
    times and even tried recreating the index
    to no avail.

    I'll try the rebind - thanks
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  5. #5
    Join Date
    Apr 2002
    Location
    Chicago
    Posts
    10
    One other thing to consider is the cardinality and distribution of keys. Even though an index is defined, the optimizer might decide to ignore using an index if it determines the access path is no better than doing a tablespace scan. As always, it depends.

Posting Permissions

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