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 |