Oracle DBMS_STATS.GATHER_SCHEMA_STATS example
So here is another post I keep mainly for my own reference, since I regularly need to gather new schema statistics. The information here is based on the Oracle documentation for DBMS_STATS, where all the information is available.
So if you want to COMPUTE the statistics (which means to actually consider every row and not just estimate the statistics), use the following syntax:
Read the rest of this entry