How to get the number of global references for a dynamic sql statement

Question

Question

CM Wang · Aug 16, 2017

#Object Data Model #Caché

In $system.SQL.Shell(), it would also report the number of global references for a given query.

Is it possible that I could also get this statistics from the %SQL.Statement interface when I launch a dynamic sql?

Thanks.

Discussion (4)1

Log in or sign up to continue

Thiago Zenaro · Aug 16, 2017

Hi,

Take a look at this link

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQLOPT_optquery#GSQLOPT_optquery_stats

Search for "Display Query Performance Statistics". There you'll have some examples on how to get SQL statistics at runtime

1 0

score 0 · Answer 1 · 2017-08-17T05:31:19-04:00

Thiago, maybe re-post your Comment as an Answer. That way the OP can set the checkmark alongside your answer, so the question no longer lists as "unanswered". Plus, you get credit.

score 0 · Answer 2 · 2017-08-17T07:30:51-04:00

Thiago Zenaro · Aug 17, 2017

Thanks for the advice. I have not noticed it before!

0 0

score 0 · Answer 3 · 2017-08-17T07:28:32-04:00

Hi,

Take a look at this link

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQLOPT_optquery#GSQLOPT_optquery_stats

Search for "Display Query Performance Statistics". There you'll have some examples on how to get SQL statistics at runtime