Re: Update Statistics

Posted in 1991

David Snyder — Fri, 3 May 91 14:12:36 EDT — source: Informix-list mailing list archive (1991-1998)

Harry Bochner, in your mail you wrote: > > My suspicion is that the command is obsolete, but my only reason for [...] Wrong, at least according to my Informix-Online instructor. The UPDATE STATISTICS command not only updates "nrows" in the "systables"catalog (the query optimizer looks at this value), but it also does some "proprietary" things to the database too. Just my $.02, no flames please... DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com