Re: Way to determine UPDATE STATISTICS

Posted in 1998

dengelsen@my-dejanews.com — Thu, 17 Dec 1998 09:53:10 GMT — source: Informix-list mailing list archive (1991-1998)

Hi Jung-Hui, I got the following from a informix-training. Run UPDATE STATISTICS: - in MEDIUM mode with the DISTRIBUTIONS ONLY argument for colunms that have no indexes - in HIGH mode for columns that are the first key of a composite index - in LOW mode for each column in all multicolumn indexes And look at your informix onconfig file: If OPTCOMPIND = 0 you only have to use UPDATE STATISTICS LOW Greetings, Ditmar den Engelsen -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own