IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 1 reply
  • Latest Post - ‏2013-12-25T14:33:45Z by nivanov1
JKYW_Gerald_Larose
JKYW_Gerald_Larose
2 Posts

Pinned topic Repeating query not running faster

‏2013-12-24T14:44:12Z |

Running DB2 101 fp2 on Red Hat Linux.

 

We have a query that repeats several times consecutively. The issue is that the subsequent execution times are not running faster than the first execution. I would think that the explain plan, once in the sql cache, would enable quicker times on subsequent executions.

Is there anything I can do to help subsequent executions run quicker?

 

Thanks in advance.

  • nivanov1
    nivanov1
    231 Posts

    Re: Repeating query not running faster

    ‏2013-12-25T14:33:45Z  

    Caching of SQL statements helps you avoid parsing them repeatedly, but it does not in any way affect statement execution. You will need to look at the actual plan to determine where is the bottleneck.