Re: Update Statistics question
If you are creating data distributions you can look at
the constructed column in the sysdistrib table.
Here's the query:
select
systables.tabname,syscolumns.colname,sysdistrib.constructed,mode
from sysdistrib,systables,syscolumns
where systables.tabid > 99
and systables.tabid = syscolumns.tabid
and sysdistrib.tabid=systables.tabid
and sysdistrib.colno = syscolumns.colno
group by 1,2,3,4
order by tabname,colname;
Regards,
Bill
--- Jack Mason <spamfreeemail@despammed.com> wrote:
> 7.x
>
> Is it possible to know somehow when the last time
> update statistics was run?>
> Thanks
>
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/