Re: Last time update stats ran

Chuck Ludwigsen wrote... }Art S. Kagel wrote: }> Carl Gruber wrote: }> > }> > Is there an easy way to tell when the last time an "update stats" ran for }> > a particular table? }> }> No. Create a table and have your update statistics job maintain a }> record there, perhaps one row per database or even per table. }> }> Art S. Kagel } }Beg to differ Art. Look at the contents of sysdistrib and notice the column }named constructed. That is the date the distribution info was generated by }update statistics. Beg to differ, Chuck. This only works if you have distributions on the table; if you are relying on 'update stats low' (which is certainly a valid tactic for many tables) there is no entry, and therefore no way to return the date value. David Coburn