Re: Last time update stats ran

In article <01bcbae6$4953bbc0$ae1893cf@cludwigsn2>, Chuck Ludwigsen <cludwigsen@worldnet.att.net> writes >Yes Manoj, this is for High and Medium and extends to the column level if >you include some of the other items from the sysdistrib table. We don't >perform up stats low because it provides no distribution info to the >optimizer. It simply notes the true number of records in the table and >what indexes exist. > >I usually perform a high on the keys only. I will also run a medium on the >whole table (before the high keys) if there are areas in the application >that involve 'where' clauses on non-key columns. Every DBA has a different >approach and it usually amounts to trying to out-smart the optimizer. I >have heard that Informix is working on options to 'hint' the optimizer. When I took the Online Performance Tuning course at Informix in June 1995 the instuctor told us that it why OPTCOMPIND was introduced, it is the start of Informix allow you to provide hints to the optimizer. The instuctor 'hinted' more things may be coming...:-> >that will really help and possibly remove some of the voo-doo like >approaches we seem to take. > >Take care. > -- David Williams