Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Executing a query just once without it using any cache

  • 1.  Executing a query just once without it using any cache

    Posted 2 hours ago

    Hi everyone,

    I'm using Informix 14.10.FC8 and I'd like to execute a query just once without it using any cached plan or statement cache - basically, I want it to be fully re‑parsed and re‑optimized for testing purposes.

    Is there any supported way (per‑session or per‑statement) to run a query without using the cache, or to force a one‑time reoptimization without disabling caching globally?

    Thanks in advance!



    ------------------------------
    Sh To
    ------------------------------


Related Content