| 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.
|