SAP Note 797629 - FAQ: Oracle histograms

Component : Oracle - Backoffice Service Delivery

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 :

1013912FAQ: Oracle BW performance
1008433F4 help: Long runtime with Oracle V.10
902042DBSL: Hint and profile parameter for "substitute literals"
846308Performance of SELECTs in WM using Oracle database
838725Oracle dictionary statistics and system statistics
825653Oracle: Common misconceptions
766349FAQ: Oracle SQL optimization
755342Incorrect execution plans with bind variable peeking
750631Approximations for cost calculation of the CBO
706132Composite SAP Note: Problems with Oracle 9i
690702Histograms cause long runtimes on Oracle 9
636670SYSTEM Tablespace grows too much due to SYS.C_OBJ#_INTCOL#
618868FAQ: Oracle performance
588668FAQ: Database statistics
566665rapid growing of cluster C_OBJ#_INTCOL#
539921Current patch set for Oracle 9.2.0
335415Creating and Maintaining Histograms
176754Problems with CBO and RBO
129385Database hints in Open SQL
129252Oracle DB Statistics for BW Tables
122718CBO: Tables with special treatment