All- I have a question... of course... I run update statistics with 50 sample each week. Each early monring I run sp_updatestats. Today, I had a view that became very slow. when I ran sp_updatestats or a plain update statistics on one of the tables involved the query didnt change. when I ran update statistics with 50 sample on that table, it flew. The question is how/should/can I increase the default sample size when sp_updatestats are run on this table? I thought it should take from the last update stats. Is this set when we run create statistics? I want to keep this from occuring on this table that does recieve a lot of updates, but also dont have much of a weekday window for maintenace. Ideas? Mike Michael MCDBA "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"