Re: Is it possible to see the results of Update Statistics in an

sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > > Hi everybody, > Is there any SMI table which will tell you the status of the last update > statistics run on a particular table ? When I say status, I mean stuff like the > "date" it was last run, maybe the kind of update statistics ( high/medium/low ). > Or am I wishing for the moon ?? For some reason this posting just showed up for me today. On the off chance that noone replied before the table you are looking for is sysdistrib in each database. You can see its columns in dbaccess/isql [TABLE][INFO]sysdistrib Art S. Kagel