Additional Cached Query generation while execution

Question

Question

Ashok Kumar · Jul 14

#SQL #InterSystems IRIS #InterSystems IRIS for Health

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.

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 (3)1

Log in or sign up to continue

score 0 · Answer 1 · 2024-07-14T12:15:52-04:00

Robert Cemper · Jul 14

how do you identify 2 cached queries generated at the same time?
and if so, what is the difference ?

0 0

score 0 · Answer 2 · 2024-07-14T13:46:54-04:00

Robert Cemper · Jul 14

This docu on Cached Queries may be an explanation of what you identified

0 0

score 0 · Answer 3 · 2024-07-14T14:14:32-04:00

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.