Re: Update Statistics

> Does anyone have a recommendation on how often the update statistics > command should be run? > Should it be run as an adminstrative routine, or started up at the > beginning of each .4gi(.4go for some) Good question. I don't run it all, and haven't noticed any ill effects. My suspicion is that the command is obsolete, but my only reason for suspecting it is this: in the earliest versions we had (< 2.0 ?), the status command (under Info) didn't return an up-to-date count of number of rows unless you did an 'update statistics' first. Starting somewhere in version 2, however, I noticed that this count always seemed to be up-to-date even if I didn't bother with 'update statistics'. So it's not obvious to me that it is still needed. A quick look through the system tables in appendix B doesn't reveal anything else it might be updating, but I haven't really tried to experiment with it, and I don't have any inside information. Does anyone (who is willing to tell us) know for sure? -- Harry Bochner -- bochner@das.harvard.edu