How to get the number of global references for a dynamic sql statement
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
Comments
Hi,
Take a look at this link
Search for "Display Query Performance Statistics". There you'll have some examples on how to get SQL statistics at runtime
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.
Thanks for the advice. I have not noticed it before!
Hi,
Take a look at this link
Search for "Display Query Performance Statistics". There you'll have some examples on how to get SQL statistics at runtime