• 1 reply
  • Latest Post - ‏2013-12-25T14:33:45Z by nivanov1
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
    231 Posts

    Re: Repeating query not running faster


    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.