Re: Last time update stats ran

You are, of course, technically correct David. As was I to Art. As was Art to Carl. Boy, this sounds redundant ;-). Anyhow, see my reply to Manoj about Update statistics strategies. I guess it all boils down to what did Carl really mean by his question. Hopefully, we each helped him a little and collectively helped him a lot. Take Care David, nice to here from you again. Chuck. David Coburn <David_Coburn@wvccg.wvus.org> wrote in article <5unm1m$rb3@cssun.mathcs.emory.edu>... > 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