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