SAP Note 448380 - Information: Oracle Package DBMS_STATS

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/448380 (SAP Service marketplace login required)

Key words :
<estimate percent>null => 'compute'<number> => 'estimate sample <number> percent' <method options>, terms adapt statistics tuning cbo explain access path distinct reason, null => table default<number> => explicit parallel degree                        dbms_stats, oracle8i supplied pl/sql packages reference, =index-statisticsc1        objectnamec4        columnnamec5        ownerwhole contents, column    description------    --------------------------statid    statistic set idtype, password>declare  distinct_values number, '<estimate percent>', statistic id 's1' isused, optimal access path

Related Notes :

1485841ALTER INDEX REBUILD does not backup old index statistics
1095171Exporting index statistics via DBMS_STATS fails
756335Statistics in tables w/ heavily fluctuating volumes of data
724545Adjusting the CBO statistics manually using DBMS_STATS
588668FAQ: Database statistics
176754Problems with CBO and RBO