What is the difference between DBMS_STATS and ANALYZE?
DBMS_STATS is a more recent method for creating statistics that is expected to replace ANALYZE in the long term. You can observe the following differences when using DBMS_STATS instead of ANALYZE: * Advantages of DBMS_STATS: o It is possible to use histograms for global statistics of partitioned objects o Table-internal parallel processing is possible (Note 408532) o Correct statistics even for columns with identical character strings in the first 32 characters (Note 365480) o You can transport statistics to other systems o You can back up and reactivate statistics * Disadvantages of DBMS_STATS: o DBMS_STATS only determines statistical data that is relevant to CBO. For monitoring purposes, the system does not calculate useful columns such as AVG_SPACE, EMPTY_BLOCKS, AVG_SPACE_FREELIST_BLOCKS or NUM_FREELIST_BLOCKS. As a result, you cannot make assertions about space utilization and fragmentation on the basis of this value with DBMS_STATS statistics, for example. o No statistics for clu
