[progress Communities] [progress Openedge Abl] Forum Post: Re: Sql-92: Update Statistics...

  • Thread starter Thread starter Martyn Reid
  • Start date Start date
Status
Not open for further replies.
M

Martyn Reid

Guest
Thanks kirchner, I'm comfortable querying the system tables... indeed I've found the _systblstat table and where _property = 4 I can get reasonably accurate row counts as long as the statistics are up to date... Can I use this command to update all tables at once?.. UPDATE TABLE STATISTICS; COMMIT; In your experience could this take a long time on a large-ish database? (say 100GB)

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