First off - I'm not sure what I'm doing....
I'm wondering if the query below will be give me accurate Progress table sizes.
I'm getting values in the value field that seem consistent for what I think the table size may be.
How do I know if the query is accurate?
How do I know what a value of 788,556,247 means? What is measured in? This is my largest value.
Any and all help will be greatly appreciated it.
SELECT *
FROM OPENQUERY(linkedservername, ' select t.id, t.tbl, t.creator, s.value
from sysprogress.SYStables t
left outer join sysprogress.SYSTBLSTAT s
on t.id = s.TBLID
')
I'm wondering if the query below will be give me accurate Progress table sizes.
I'm getting values in the value field that seem consistent for what I think the table size may be.
How do I know if the query is accurate?
How do I know what a value of 788,556,247 means? What is measured in? This is my largest value.
Any and all help will be greatly appreciated it.
SELECT *
FROM OPENQUERY(linkedservername, ' select t.id, t.tbl, t.creator, s.value
from sysprogress.SYStables t
left outer join sysprogress.SYSTBLSTAT s
on t.id = s.TBLID
')