A STATS Solution......

Database
Enthusiast

A STATS Solution......

Hi All,
Can any one suggest me with an macro or SQL to find out the tables that lack stats in a specified database.
The Code should find out the tables that either have no stats on P.I column or have old stats on P.I Column(say the table should have stats collected each month but sometimes as it is developed by more developers these stats are left un-collected in my proj).
I guess that Stats Wizard can help in this situation but my manager wants a code developed by us.
Can someone please throw some light on this..........
1 REPLY
RMM
Enthusiast

Re: A STATS Solution......

Hi Ragav,

I have the necessary query for that , will provide you soon.
I can provide the one which is highly skewed with some justification ....

Cheers,

Rishikesh