Gather table stats sample size

Hi Team,
               We need to come up with a sample size for running DBMS_Stats.Gather tablestats procedure. The tables on which stats need to be collected are very large (Some of the tables are more than 25 G with the largest table being 95 G and has 600 million rows). How to come to a reasonable sample size for estimate. Would you recommend Auto sample size. We use a sample size of 4 for large tables as a general rule (in this environment). Completion time of the stats gathering is a factor in this calculation.
Thanks and Regards,
Rajesh K.
rajkeshavAsked:
Who is Participating?
 
sdstuberCommented:
We generally use auto unless it doesn't seem to do a good enough job, which generally only happens if there is a lot of skew.

Unfortunately, only you can tell us if that's the case, and if so, you may have to play around with it.

How many indexes are on the table?  The more indexes, the longer it will take to analyze.
0
 
rajkeshavAuthor Commented:
Hi Team,
            Any thoughts on the above question??

Thanks and Regards,
Rajesh K.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.