Solution : https://service.sap.com/sap/support/notes/797629 (SAP Service marketplace login required)
Key words :
sap parameter dbs/ora/substitute_literals, analyze table t100 compute statistics, c_obj#_intcol# oracle cluster, dbms_stats command gather_ _stats, num_bucketsfrom dba_part_col_statisticswhere owner = '<table_owner>', select statement optimizer=choose, dbi hints substitute values, dbi hints &substitute values&, [indexed] columns [size <buckets>], terms faq solution 1
Related Notes :
| 1013912 | FAQ: Oracle BW performance |
| 1008433 | F4 help: Long runtime with Oracle V.10 |
| 902042 | DBSL: Hint and profile parameter for "substitute literals" |
| 846308 | Performance of SELECTs in WM using Oracle database |
| 838725 | Oracle dictionary statistics and system statistics |
| 825653 | Oracle: Common misconceptions |
| 766349 | FAQ: Oracle SQL optimization |
| 755342 | Incorrect execution plans with bind variable peeking |
| 750631 | Approximations for cost calculation of the CBO |
| 706132 | Composite SAP Note: Problems with Oracle 9i |
| 690702 | Histograms cause long runtimes on Oracle 9 |
| 636670 | SYSTEM Tablespace grows too much due to SYS.C_OBJ#_INTCOL# |
| 618868 | FAQ: Oracle performance |
| 588668 | FAQ: Database statistics |
| 566665 | rapid growing of cluster C_OBJ#_INTCOL# |
| 539921 | Current patch set for Oracle 9.2.0 |
| 335415 | Creating and Maintaining Histograms |
| 176754 | Problems with CBO and RBO |
| 129385 | Database hints in Open SQL |
| 129252 | Oracle DB Statistics for BW Tables |
| 122718 | CBO: Tables with special treatment |