[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Last time UPDATE STATISTICS was run?

  • Thread starter Thread starter steve pittman
  • Start date Start date
Status
Not open for further replies.
S

steve pittman

Guest
Run this query in your favorite sql client: select max(val_ts) from sysprogress.systblstat; There is a timestamp in the rows written to the various statistics tables. It’s possible that different stats tables got updates at different times. A similar query will work on the other stats tables. This query has to be run be a DBA or someone granted Select permission to the tables/views queried. Statistics tables should have authorization carefully administered and granted, since the content of these tables shows important info about the underlying application tables. Hope this helps, ….sjp

Continue reading...
 
Status
Not open for further replies.
Back
Top