Re: Updating statistics

Art, Sorry if I am being a little dense about this but I have a question about one of the suggestions you made to Mr. Brieck. In answer to question 3 you said: | |> 3) Are there any other resources to consider before using distributions on a |> large scale? | |Yes the data distribution cache (onstat -g dsc). The default cache is |managed by a hash table with 31 buckets and either 20 or 127 entries per |bucket (depending on the version, onstat -g dsc reports the current values). |If you have more than the default number of active tables (or even close to |the number) you may want to increase the hash table size by adjusting the |undocumented ONCONFIG parameters DS_HASHSIZE (must be a prime number, default |31) and DS_POOLSIZE (usually a small integer, default 20 or 127). | The current output from my onstat -g dsc is: Informix Dynamic Server Version 7.31.UC3 -- On-Line -- Up 3 days 06:04:42 -- 326656 Kbytes Distribution Cache: Number of lists : 31 DS_POOLSIZE : 127 Number of entries : 63 Number of entries in use : 0 Is the number of entries supposed to be compared to the number of lists or to the DS_POOLSIZE? Thanks for the clarification. Dale Forrey Washington State University