From:Steve Adams
Date:27-Jul-2001 07:23
Subject:   Were statistics gathered with compute or estimate?

SAMPLE_SIZE in DBA_TABLES will be zero if the statistics were gathered with COMPUTE and non-zero if they were gathered with ESTIMATE.

Is there an easy way to determine if statistics where run as compute or estimate? I looked at DBA_TABLES and LAST_ANALYZED tells you when they were run. If I had a partitoned table it sounds like GLOBAL_STATS would answer my question.