Additional Cached Query generation while execution
Hello Community,
I've seen two cached queries are generated while executing a query. So, Why the additional query is generated and what is the use of it.
.png)
Product version: IRIS 2024.1
$ZV: IRIS for Windows (x86-64) 2024.1 (Build 267.2) Tue Apr 30 2024 16:42:56 EDT
Discussion (0)0
Comments
- how do you identify 2 cached queries generated at the same time?
- and if so, what is the difference ?
This docu on Cached Queries may be an explanation of what you identified
Thanks @Robert Cemper
I've go over the documentation and the hash value represents that's an embedded SQL cached query and ends with integer is dynamic SQL. But why the both cached queries are generated while running the sql in management portal. AFAIK, I haven't seen these two cached queries in some other versions.