Results 1 to 2 of 2

Thread: MQT not hitted

  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: MQT not hitted

    Hi All,

    i have an issue that , when the base table is created with MDC , my queries are not hitting the MQT .

    in detail,..........

    when my base table is NOT created with MDC , my queries are hitting the MQT. But when i create the base table with MDC , the same queries are not hitting the MQT. instead , it is going to the base table.

    any idea why this strange scenario happens?

    My DB2 version is 8.1 / Unix Platform

    Thanks,
    Arun

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    My guess is that the DB2 optimizer thinks that accessing the MDC is cheaper/faster than querying the MQT. Do you see differences in the execution times of the query? If so, which one is faster?

    Try to install the latest FP. If you are on V8.1, you will find several newer fixpaks, and each fixpak typically contains improvements for the optimizer.
    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
  •